I have 2 databases with the same structure, but different data.
I want to put all the data in 1 database.
The problem is that the most important table (clients)has an autonumeric id field, that is used to link the records to the fields of many other tables;
so, I cannot delete or change that field without losing connections.
Is there a way (VBA?) to work around this problem?
TIA
Dirk
I want to put all the data in 1 database.
The problem is that the most important table (clients)has an autonumeric id field, that is used to link the records to the fields of many other tables;
so, I cannot delete or change that field without losing connections.
Is there a way (VBA?) to work around this problem?
TIA
Dirk