I've got a field on Layout A (from Table A) that displays a values from a value list in a dropdown. The value list displays values from Table B which is a personnel table. So the field on Layout A displays "Last & First" when the dropdown is clicked in browse mode. I would like to set up a button action to go to the related record in the personnel layout but something isn't set up right, I'm guessing in the relation between the tables.

How should the relationship be set up to get the button action to work to go to the related record in a different layout/table?

The field the button action is on is "Safety Clearance:Primary Authorized Employee". The value list inputs values from "Personnel:Last". And I have a relationship between the tables established as Safety Clearance:Primary Authorized Employee = Personnel:Last.

Nevermind. I got the same effect by writing a script to copy the filed with the name, change to the personnel layout, enter find mode, paste and find.