AnsweredAssumed Answered

I'm missing something??

Question asked by sblake on May 6, 2017
Latest reply on May 8, 2017 by beverly

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 1Header 2Header 3Header 4
CompanyNameCompanyStatePlantNamePlantState
Company1New YorkPlantAMaine
Company1New YorkPlantBNew Hampshire
Company2CaliforniaPlantCOregon
Company2CaliforniaPlantDNevada
Company2CaliforniaPlantEWashington
Company3OhioPlantFOhio
Company3OhioPlantGIllinois
Company3OhioPlantHMissiouri
Company3OhioPlantINorth Dakota

 

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.

Outcomes