I have setup a master database with satelite databases running off satelite machines. The idea is that the satelite machines will complete a record and then export that record to floppy to be then imported to the new machine.
The make up of the database is as follows. Consultant ID in Consultant Table linked by a a one to many relationship to Consultant ID in Illustration Table. The Illustration ID in the Illustration Table is then linked with a One to Many to 3 sub tables.
If I export all 4 tables stored on an individual Illustration ID as separate files then when this is imported into the master database this will cause me a problem as the satelite machines will also have the same Illustration ID numbers and therefore the master data base will not be able to distinguish which records in the subtables belong to which record. can anyone help ?
The make up of the database is as follows. Consultant ID in Consultant Table linked by a a one to many relationship to Consultant ID in Illustration Table. The Illustration ID in the Illustration Table is then linked with a One to Many to 3 sub tables.
If I export all 4 tables stored on an individual Illustration ID as separate files then when this is imported into the master database this will cause me a problem as the satelite machines will also have the same Illustration ID numbers and therefore the master data base will not be able to distinguish which records in the subtables belong to which record. can anyone help ?