Displaying foreign key field without using Popup menu

[aalrr1]

In order to avoid popups in Value Lists, yet display foreign key field rather than primary key, I figured out the drop down menu covered by a non-enterable edit field (thanks to a forum answer) in a simple 1-to-1 relationship.

However, I can't make it work in a 3 table relationship where a Popup Menu works. An Employee table holds all employee names and logins (primary key). Attorney and Secretary tables hold fields unique to each. Both tables are linked to the Employee table by login.

If I display data from Attorneys:SecretaryLogin by using Popup value list pulling Secretary:Login, and foreign key field from Employees:Fullname, it displays the secretary fullname. If I use, the label over a drop down menu, I don't how to display secretary fulname. Secretary:Login displays the secretary's login and Employees:FullName displays the Attorneys fullname. I assume I need to set up another relationship; I'm just not sure what.

Please help. Thanks.

[comment]

I don't understand your description at all, so here are some general guidelines:

1. A relationship is ALWAYS between TWO tables (or rather between two table occurrences) only.

2. Usually you use a drop-down/pop-up to select a parent for the child. The entry field is the foreign key in the child table, and you select from a value list of parent primary keys.

3. Once you have selected the parent record (i.e. entered the parent's primary key into the child's foreign key field), you have access to data from ANY of the selected parent's fields. You can place any field from the parent's table on a layout of child, and see the data directly from the selected parent's record.

4. If the child records are shown in a portal from a layout of another parent table (i.e. when the child is a join table between two parent tables) - you can place selected parent's fields directly in the portal, and it will work the same way.

[aalrr1]

So new to this terminology that I can't yet explain myself well. I followed your steps as detailed, and found I needed an additional relationship to the Parent table. Was able to create a new Parent-Child relationship and got it to work.