fields from two related tables in same Portal

[mopai]

I have 3 related tables:

the relationships are:

conference.confID----<invites.confID

conference.confID----<comments.confID

the invites table is also related to the comments table via

invites.invID-----<comments.invID

added.....

in the layout using conference for the currnet table

I want to have a portal that displays all the comments made by invitees for a particular conference but also have it display the first name (invites.invFname) and last name (invite.invLnama)

can some please explain how this is done?

'Thankyou

edit:

15 views but no reply. perhaps Im not being clear enuf.

I just wnat the portal to grab fields from two other related tables

and display it like this

invites.invFname | invites.invLname | comments.commDate | comments.comBody

can this be done?

[SlimJim]

You need to get the relationships in the right order and it is hard to explain. I have attached an absolutely minimal model. You can do all the data entry on the conference layout.

One caveat with this minimum model. If someone attends more than one conference then they will have multiple entries, one for each conference. If you want to avoid that then you will need another table joining conferences to invitees.

[MoonShadow]

"I have attached an absolutely minimal model."

It doesn't get more minimal. No attachment.

[SlimJim]

Whoops!!

TripleTest.zip