drop down menus - link information
I have a table in FM11 that contains participant information details including a unique "person ID". If i choose to have the 'person ID' field as a drop down menu how can i get the other fields to display the related information to this person. i have tried to make the other fields lookups but can not select the table that this information is stored on. Do i need to have another related table that has person name and surname with the personal ID? i would prefer this as an option as this will be easier to select records rather than using the find field in the toolbar.
Thanks for any assistance