June 14, 200520 yr 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?
June 15, 200520 yr 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.
June 15, 200520 yr "I have attached an absolutely minimal model." It doesn't get more minimal. No attachment.
Create an account or sign in to comment