AnsweredAssumed Answered

drop down menus - link information

Question asked by tomo_1 on Apr 15, 2010
Latest reply on Apr 23, 2010 by philmodjunk


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