Thanks to those responding to my previous question.
New problem: I've obviously missed something as I get started in my FM adventure working with relationships.
Want to create a new FM Pro file, i.e. no fields set up.
Import the following from Excel (example simplified but essentially what I am doing):
|Header 1||Header 2||Header 3||Header 4|
|Company1||New York||PlantB||New Hampshire|
The first row (below what tables shows as Headers) are the column headers in Excel and will be field names in FM.
How do I set up two tables: One for Companies (with just 3 records) and one for Plants (with 9 records)?
How do I relate them so I can have a layout that shows a company with its plants listed below AND a layout that shows company name when I select a particular plant.
I've tried several things, read and watched a lot and still can't get this to work.
Any help would be appreciated.