Portals contain info from multiple fields

[rhiannon]

Hi

I'm just a new Filemaker user so I am making my excuses from the outset.

I am trying to create a database to handle event scheduling.

At the moment I have three databases that talk to each other -

1. Personal contact details

2. Organisation details

3. Program details (we run a festival so this includes fields like session title, start & end times, date, venue, speaker 1, speaker 2, speaker 3, speaker 4 etc.)

The speaker 1, 2, 3, 4, fields in "program details" have drop down boxes of all the contacts in the "personal contact details" database.

I'd like to be able to create a personal schedule for each speakers (must update automatically when changes to the program are made) in the "Personal Contact Details" but the only way I can figure out to do this is to create a portal for each of the speaker fields.

This seems very clumsy - I basically want a function that will look for the person's name in each of the speaker fields and then list all the sessions they're appearing in and the associated program details.

eg

Personal Contact details

John Smith

session 1. Environmental Issues, Sun 3 Oct, 9am - 10am, speaker 1, speaker 2, speaker 2 venue: Town Hall

session 2. Water Management, Sun 3 Oct, 9am - 10am, speaker 1, speaker 2, speaker 2

etc.

Is my query clear enough for anyone to suggest anything that might help solve this?

many thanks

R

[Wim Decorte]

A portal is what you need, in the personal contact file. The portal would show related records from the sessions database.

Since you have multiple speakers per session you probably need a SessionSpeakers database that is related to sessions by sessionID. The portal in the personal contact table would then show related records from the sessionSpeakers table.