has_access
New member
- Local time
- Today, 13:27
- Joined
- Aug 15, 2018
- Messages
- 9
Hi all
I have a database with 2 tables (Patients and Visits) , with one-many relationship (1 patients ---> to many Visits)
in Patients table, we have Patient_ID, Patient_name
visit table, we have visit_ID, visit_date , visit_description
I want to add this procedure:
when I enter a new patient's name in the add new patient form , it check whether this name is present in the patients table, if it was present, then it Automatically open a new form showing that patient info and visits.
Thank you in advance.
Has essa
I have a database with 2 tables (Patients and Visits) , with one-many relationship (1 patients ---> to many Visits)
in Patients table, we have Patient_ID, Patient_name
visit table, we have visit_ID, visit_date , visit_description
I want to add this procedure:
when I enter a new patient's name in the add new patient form , it check whether this name is present in the patients table, if it was present, then it Automatically open a new form showing that patient info and visits.
Thank you in advance.
Has essa