dynamic constraint ?

[mopai]

I have two tables

conference and invites.

Related like this, conference.pk_confID----<invites.fk_confID

I have a layout that displays all the conference data for each conference record.

I have a button on it that I would like to set to switch to a layout that displays all the invite records for which ever conference record the previous layout was on.

essentially what I am asking is how do you pass the current confID thru the button to the invites layout to constrain the found set to only show invites for that conference.

This should be simple but I can not figure it out.

thankya all

[SlimJim]

Define your button to Got To Related Record and choose to show only related records.

[RalphL]

It looks like a many to many relationship. A conference has many invites and an invite may go to many conferences. In this case you nedd a join table. The relationships are conference.pk_confID----<join.fk_confID and invites. pk_invitID----<join.fk_invitID.

You don't really need a button, add a portal to the join table. The portal will display the invites for the conference.

[mopai]

nope one to many.

there are many conferences and there are many invites but each invite is related to only one conference. There are no invites going to more than one conference.

Also

the button I want to have perform a script that opens a new window, puts it in preview mode and prints the report automatically. I actually got this part down. Its just constraining the found set to the current confID thats making me lose what little hair I have left

soooo. just assigning the button to open related records doesnt seem to work for me. Of course I am new to Filemaker. Perhaps I am missing more than I think I am

[SlimJim]

Tag the GTRR (show only related records) on to the front of your script and attach the script to the button.

[mopai]

ahhhh GTRR gotcha thanks