Populating drop down from field in different table

[mopai]

Yes me newbie alright!

Ill do my best to describe the issue I am attempting to resolve.

I have two tables, conferences and invites. I have related the field

conferences.confID to invites.confID (one to many).

I would like to create a layout that would display invitations per conference.

I envisioned, and this may be completely the wrong way, having a dropdown on the layout populated with all the conference records (confID, confTitle)from conferences and hopefully be able to [color:"red"]select/click a particular conference from that dropdown and then finally [color:"red"] display all the invites (invites.confID) to that conference (conference.confID)

Can it be done with one click like discribed above??

Thanks your direction is appreciated very much

[Fenton]

If you're going to be selecting from any conference ID, the choice field should be a global. Then you create a relationship from that global to the confID in the Invites table. You can show the many results in a portal. It's a 1-click thing. But it looks best if the portal fields are non-enterable, so they don't get all highlighted. Otherwise click outside the field to commit the change.

count (global relationship::confID) is the count of the related records. Put at the top right of the portal.