AnsweredAssumed Answered

Field Lookup from related table

Question asked by dennismoorejr on Jun 29, 2017
Latest reply on Jul 8, 2017 by philmodjunk

I have the following issue that I am struggling with.


I have a "Participant" Table which consist of the following fields







I have a seperate "Incident" table consisting of the following fields







On the incident layout I would like to have the name field populated from a drop down menu which will auto fill and bring along the proper coding.



ID record number 1 consist of

IDpk =1

IDFirstname = John

IDLastname = Kennedy


Incident page layout would have fields


[First Name] [Last Name]


I would the drop down menu to auto populate or select John Kennedy then once selected it would fill in the first and last name fields along with the proper IDfk so when back on another related layout a portal under John Kennedy's record would show the incident.


I have the portal part completed.  My issue is the selection of the name from the drop down menu to populate into the proper name field and also attach the proper IDfk.



I have the tables related via the IDpk and IDfk.


Thank you in advance.