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
