Hello,
I have an excel sheet about operated patients.
Columns include: patientID, firstname, middlename, surname, address, surgerydate, ... (10 more columns related to surgerydate), surgerycode, surgeryname
(PatientID is actually unique IDCard numbers of citizens, however there are foreign patient records who are missing a unique PatientID)
1. Patient may be operated once, with one surgery code
2. Patient may be operated once, with more than one surgery code
3. Patient may be operated more than once, with one surgery code
4. Patient may be operated more than once, with more than one surgery code
Because of these possibilities, i created 3 tables:
1- PatientDemographicsTable: DemographicsID (primary key), PatientID, firstname, middlename, surname, address
2- SurgeryDateTable: SurgeryDateTableID (primary key), DemographicsID, PatientID, SurgeryDate, ... (10 more columns) --> Linked to table above with DemographicsID
3- SurgeryCodeTable: SurgeryCodeTableID (primary key), SurgeryDateTableID, PatientID, SurgeryCode, SurgeryName --> Linked to SurgeryDateTable with SurgeryDateTableID
I tried to import data into access, however i failed because of repeating records.
Do you know any way to do it?
Since i failed to do it, i created excel tables with the same access table fields, then i imported, now all data is in access in tables described above. However, as you can guess, i cannot copy the primary keys of parents to the childs.