Display records in Portal
I have 3 related tables.
Table1 has a portal to show related records from Table2.
Table3 holds IDs and person names.
On Table2 I select a person name from Table3 thru a popup box with a value list of IDs and show second field as person name.
When I make the portal in Table1 I want the person name and not the ID number .
How do I get the related record from Table3?