AnsweredAssumed Answered

Location, Locations,. Locations

Question asked by arthursc on Dec 6, 2011
Latest reply on Dec 13, 2011 by arthursc

Hello,

 

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;

__PK_Estate_ID

Estate Name

Add1

Add2

Add3

Add4

city

County

Postcode

Tel Number

 

The Primary Location Table will consist of;

__PK_Primary_Location_ID

__FK_Estate_ID

Location_Name

Grid ref

 

The Secondary Location Table will consist of;

__PK_Secondary_Location_ID

__FK_Primary_Location_ID

__FK_Estate_ID

Location Name

Grid ref

 

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.

 

Regards

Colin.

Outcomes