Years ago I used an access book that provided for a very complicated contact management schema that has been biting me in the backside ever since. The main contacts I need to manage are clients, but there are also various 3rd parties like doctors. The address management was a many to many and like I said, too complex, and too unwieldy. In my MS access DB I had the bright idea of "subclassing" contacts.
I have a Contacts Table and a Client Table. Contacts is everyone, client is, well, clients. Because the address management "broke down" I shifted to simply housing address and other data for clients in the client table.
I had a hard drive crash this week and lost many MS DB client records. I use the MS DB to populate Acrobat forms for client signature. Those signed client document are stored on the Adobe cloud. You can click on a file in the above dashboard and get "download form field data" which gives you a csv file of this form's data (name, DOB, Address, etc) which can help me to repopulate my MS database. I have managed to merge these separate csv files and this is the source of data I want to use. But my client table has a vestige of the folly of following a complete MS Access book!
In my Clients table I have a foreign field, ContactID, as primary. That field, ContactID is autonumber, primary in table Contacts. So when I import my data from the csv file I have
1. Client a record in table Contacts
2. Create a record in table Clients with the ContactID just created in table Contacts
3. Add the rest of the data in the csv file to that created record in table Clients.
Any help would be most appreciated.