I have a database used for tracking patient eligibility for studies. I have a table that stores all the patient’s data that needs to be recorded, a table that stores the eligibility information for all studies on each patient, and a lookup table that lists the studies currently being conducted. The patient data is entered on a form. The study information is recorded using a combo box on a subform to create a record for each study.
My questions is, is there a way to automatically create a record for each study once the patient data has been entered and not use a combo box? There have been times when the same study has been selected twice for one patient. We don’t want more than one record created for each study per patient.
My questions is, is there a way to automatically create a record for each study once the patient data has been entered and not use a combo box? There have been times when the same study has been selected twice for one patient. We don’t want more than one record created for each study per patient.
