Jump to content

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

Recommended Posts

Posted

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!

 
Posted

Oh, and to be more specific, I set up my "detail" layout/tables just like spreadsheets, with rows and columns. I want to be able to click on the ID or row and then toggle back to the Gen Info layout/table and have that matching ID record automatically show up. 

Posted

Assuming you have a relationship (or rather relationships) between the parent (Transects?) table and the child tables, based on matching ID, you can use the Go to Related Record[] script step to move to the parent record (and layout).

 

 

I have four different tables, each with an individual layout, that are gathering information on a specific transect line

 

Do you really need four different tables for this?

This topic is 3765 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
×
×
  • Create New...

Important Information

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