I am a rank FMP 7 newbie so please help point me to the correct forum

I have two tables

conferences and invitations. These are related via conferences.pk_confID ->invitations.fk_confID

need( would like) to create a layout ( call it view invites by conference) that will display all invitations to a particular conference.

How do I...

1 create a portal(?) to display all conferences with in the layout

2 allow the user to select a particular conference from the portal

3 automatically update the layout to display invitation from the selected conference.

Perhaps I should post this under the protal forum but Im not really sure that a portal is the answer here.

Thanks fer the help

Welcome to the Fourm:

It looks like you may have a many to many relationship. I assume that Invitation is a table of people that are invited. The same people may get invited to more than one conference. And a conference will invite many people. This means you will need a join table. The relationship between conference and join is conferenceID. The relationship bewteen people and join is peopleID. You may want to change the name of invitation to people and name the join file invitation.

Thanks for the reply. As I got farther into it I figured this is a layout/scripting issue so I posted in the layout forum. I hope a little more descriptive also.