May 11, 200520 yr 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
May 12, 200520 yr 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.
Create an account or sign in to comment