Hi - I’m trying to develop an app that can manage admissions to a hospital for instance.
I want to use my existing database with all the existing info where possible. So I have a table with existing patient data in. The patient Identity number (E.g. Social Security Number) forms the unique ID/key. So I have created a view where the patient enter his ID number, then next takes you to name and other details.
However what I want to do is once the ID number is entered, it needs to first verify whether the ID already exist or not. If not, it is easy, but if it does exist, I want to use the surname as a password in order to load existing data and update it. I know I can use the List/Ref function, but I don’t really want to do this as it could lead to security issues around personal info.
So when the patient arrive,
they punch in their ID number. If it doesnt exist, they provide all their details. If it exists, they need to provide their surname as password. If Correct, they can edit their current info.
How do I go about this?