3 Replies Latest reply on Nov 6, 2014 2:56 PM by philmodjunk

    help with linking individual records from other tables back to one main table

    StephanieLawless

      Title

      help with linking individual records from other tables back to one main table

      Post

      I am new to filemaker pro and have a specific question here. I have four different tables, each with an individual layout, that are gathering information on a specific transect line (we are collecting botanical data on many transects along rivers). I made a "general Information" table with a layout that has specific information I need to gather on each individual transect. The other tables are there to enter different data on individual transect lines. Here is my question. I created an ID field on my general information page to identify each transect. Whenever someone enters info into a record on other tables for that transect, they start by entering the first field on the record with that ID. Now, let's say I am on another table layout and scroll through all of the data entries from different transect lines. If I click on one transect line, for example, #MA13, how can I set up my database so that when I click back onto my "general info" page, the #MA13 record shows up? Right now I can only flip through the records to look back at the general info from that transect data. 

      Thanks for your help!