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
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.