Can one select records from a portal to update the displayed layout?
I'm trying to display fields from the table a portal contains on a layout that is for a different table. I want to be able to click on the field in the portal and have it update the fields displayed in the layout. Here's my scenario:
I have a "Tourer" table which contains information on someone taking a tour. That's the layout I'm using for this also - mainly the Tourer table fields. On the layout I have a portal, which shows the tours the person has taken (Member Tours). They get sorted. I can add tours using the portal and delete them. I also show fields on this layout that correspond to the Member Tour .
What I want to do is to be able to click on one of the portal entries (Member Tour Code) and have the fields corresponding to that tour display on this layout.
I have a pared down version of the DB if that would help, I just don't know if it's right to post it here or not.
Thanks for any help,