AnsweredAssumed Answered

Creating multiple related records and displaying each on separate tabs

Question asked by amandahbell on Mar 17, 2015
Latest reply on Mar 17, 2015 by philmodjunk

Title

Creating multiple related records and displaying each on separate tabs

Post

OS: Windows 7

Product:  Filemaker Pro Advanced 13

 

My Schema

Site--<Transects--<Transect Points

 

Each site has 11 transects and each Transect has unlimited points.

 

For each Transect all of the information collected is the same. As is the information for each transect point.

I want to be able to flip through them quickly so I thought putting together a Tab Control with 11 tabs name T1-T11 would work well.

I don't want to do a portal because I want the use to focus on one transect at a time.

Here is where I'm stuck:

1) I need to create 11 transects when I create a new Site Record--What script do I use?

2) I need only the Transect information for the transect number that is displayed to show up on each tab.

 

I already have a script on a main page to create a new record so I assume that I could add another script to that button to add the transects and number them.

I also have a Value that displays the Current Tab Number.

Outcomes