Jump to content

Auto-display of related data


courgettelawn
 Share

This topic is 5675 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am putting the finishing touches to my first Filemaker Pro database which is documenting various artefacts I have been researching for my PhD. The database is relatively simple with one main table and two related tables. The link between the three tables is the Record_ID which is just an auto-entry running number series. Record_ID is the foreign key in the two related tables. I have 3 layouts (Object, Provance and References) based on the three tables and Record_ID appears in all three so I know at a glance that the correct data has been entered for any given object record. I would like the Record_ID data which auto-enters on the layout related to the main table (Object) to also appear in its related fields in the other two layouts (Provenance and References). I have tried finding out how to do this via Help but without luck and the only way I can make the tables work together is to manually add the relevent Record_ID number in the related Record_ID fields on the Provencance and References layouts.

What is the best way around this? Your advice will be much appreciated!

Many thanks,

Tehmina

Link to comment
Share on other sites

  • Newbies

Have you set up the relationships in the 'Define Database' panel? In my database which has a similar structure to yours, I have the main record have an auto generated serial and a portal for each of the 2 other tables which in the database structure all share the reference from the first table.

Link to comment
Share on other sites

This topic is 5675 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.