I am looking for advice on how I create the relationships for the following criteria;
I am designing a DB for Estates Management. The criteria for this is thus;
Each Estate can have MULTIPLE Primary Locations.
Each Primary Location can have MULTIPLE SECONDARY Locations.
I want to bring this together on one Layout so the administration and user input is simplified.
The Estate Table will consist of;
The Primary Location Table will consist of;
The Secondary Location Table will consist of;
Is the above correct to enable me to create the relationships? How do I join them so that all the data is available for input from one layout. I assume that from within the Estates Layout the Primary and Secondary tables would be portals??
A simple relationship example would be very helpful and if possible a simple layout design example.
I am relatively new to FM and am using FM Pro Adv 11.