Need help with merged fields in dropdown
So I have a table populuated with first name and last name fields (Residents' Registration) and a related table which uses the Resident_Registration_PK number as a foreign key. (Treatment Plans)
I would like to have a dopdown on the threatment plan that will display both Last names and first names on a drpodown list, or a script which creates blank treatment plans for each which will automaticall create a single treatment plan for each name.
How do I go about in doing this? should I create a portal? Im deploying this via IWP ...