- Joined
- Mar 29, 2012
- Messages
- 1
- Reaction score
- 0
I am trying to update client records from information provided in a Zoho online form - a csv file. The data, however, is spread over several tables and involved one to one and one to many relationships.
My Zoho form asks my client to give me details on the medications they are currently taking. But this simple request has implications across the tables. A medication is a MedicalTreatmentEvent, which has its own autonumber. And a MedicalTreatmentEvent pertains to a given medical condition, an ClientImpairment which has its own autonumber, ClientImpairmentID. So when the client enters "Dpression" in the "what for" blank in the Zoho form, we know this entails creating a record in ClientImpairment and getting a ImpairmentID autonumber issued. And of course the MedicationID has to be linked to MedicalTreatmentEventID, so there are just a few moving parts here. I don't know whether my VBA code should break it up, or try to achieve it in one big append query?
My Zoho form asks my client to give me details on the medications they are currently taking. But this simple request has implications across the tables. A medication is a MedicalTreatmentEvent, which has its own autonumber. And a MedicalTreatmentEvent pertains to a given medical condition, an ClientImpairment which has its own autonumber, ClientImpairmentID. So when the client enters "Dpression" in the "what for" blank in the Zoho form, we know this entails creating a record in ClientImpairment and getting a ImpairmentID autonumber issued. And of course the MedicationID has to be linked to MedicalTreatmentEventID, so there are just a few moving parts here. I don't know whether my VBA code should break it up, or try to achieve it in one big append query?
