I am a new user to Filemaker looking to move my training diary into a database. I have my tables set up and am now trying to build a layout to view and edit the data. I've done a lot of searching online and made some progress but am now stuck.

The basic structure of my database is:

Training Diary which contains multiple training days which contain zero or more workouts which contain zero or more swim workouts.

What I want to do is display a training dairy and let users add / view training days and from there select a day and show the workouts and select a workout and display the swim workouts.

So far I'm managed to display the workouts for a given day by using a button in the Training Day portal which sets a global variable for the selected Training Day's primary key. Using this I can display the workouts for that day and edit them.

I want to do the same for the swim workouts so I've added a button to the Workouts portal that sets a global variable for the selected Workout's primary key. It's set up as before. However whenever I click it it sets the global variable to the first workout primary key in that table. ie it does not set it to the selected row in the Workouts portal.

Any ideas ? Is there a better way to do this ?

Is the button in the selected row of the workouts table?

Yes it is.

I think I must be missing something as I'm sure that this sort of relationship must be displayed all the time.

How about a screen of the Layout, in Layout Mode.

The Relationship for the Go To The Related Record is based on the one used for the portal. You need to be sure that the Button is within all boards of the Top Row (i.e. where the fields are).

HTH

Lee

I've added a button to the Workouts portal that sets a global variable for the selected Workout's primary key. It's set up as before. However whenever I click it it sets the global variable to the first workout primary key in that table.

It sounds like you are taking the Workout's primary key from the wrong table occurrence (i.e. not the same one that's feeding the portal). Post a file if you can't work it out.

you are a star. That is it.

I still haven't got my head around table occurrences in the relationship diagram.