Hello, I'm trying to set up a clinical trial form that will update records in multiple related tables in an Access DB. The basic DB schema is that there is:
1. A tblPatients table that contains a demographic record for each patient, indexed by a unique SubjectID
2. A tblEvents table that contains a record for each medical event that occurs to the ...