For some reason this is not working for me. The dropdown correctly displays the names but upon clicking away the staff name is replaced instead by the staff ID.
Believe it or not, this is normal behavior for a drop down list. You can switch to a pop up menu format where this does not happen, or you can add a field from the staff table to show the name once the ID has been selected. One trick is to use behavior settings on this name field to deny access to the field and then position it on top of the drop down list field. When you click on the name field, the drop down list in the field behind it deploys to let you select a name. When you select a name, the drop down list disappears and the name field that hides it shows the correct name.
Yea, I'm still reconciling myself to trying to believe it!!
I've been trying to get the other method to work - it's odd that on this occasion it doesn't. I select the value list from the foreign table and select a second field from the same table (in fact, the same field as that which the value list is based on), yet this only populates once - it doesn't update if I change the staff member for a second time. If it worked, I'd just move it over the top of the dropdown, set text colours accordingly and that's sorted.
The field I am dropping down on is within a portal which may have something to do with it, I'm not sure, although I've not seen this before. The relationship is very simple from parent to child with the child being the portal.
A bit stuck on that one.
It sounds like either this field is from the wrong table occurrence or the relationship is wrong for what you need here--which is much the same problem.
You need a table occurrence where the field that gets the ID entered by your drop down list is linked to an occurrence of the table from which your value list lists values. It sounds like this is not the relationship you'd use in a portal as this relationship should match to only one record in your table and that would produce a portal that never showed more than one portal row. ;-)
Thanks for your help on this - a couple of staff table instances to track a project as it moves from person to person and the use of popup menus have solved a load of grief!
Great stuff :)