I have a MS Access database with four primary tables. The main table is called Patient and below it are 4 child-tables: Assessment, Catheter, Perithonitis and Termination. I want an import function for all 4 child-tables. The import data is in a xml-file and contains the data for one patient combined with the data for one of the child-tables (als just one occurence).
Attached you will find the application database ([url removed, login to view], which can be stored in any folder) and the database with the data only ([url removed, login to view], which should be stored C:\Projects\PD Register\Interface). Also are included some sample xml-files.