Prevent user data from being recreated
Hello,
I created a patient database witch uses several forms, patient evaluation, contacts, appointments and so on,
each form link with each other through the patient name with a Lookup field displayed as "Dropdown (single select)".
What happens is that when using the application and selecting one of the patients, that were already registered, from the dropdown:
- The fields that i have already filled wont show up, pre-filled like in the form view.
- If I write something on those fields they will create a new user with the same member name, duplicating the entry.
What can I do?
thanks,
Do I need to prevent the Lookup field from being selected? Hide it?
But if I do that how can I select the patient and make it communicate with the other sections (forms) of his file?