Hi
I have 2 tables, each have an autonumber as the primary key.
Different data will be entered into each table by different users and this all works fine.
But
On occassion, I will want to append the data for a record from tabel 1 into table 2. Currently this will cause a problem as it will create duplicate entries in the primary key.
Is there a way that the autonumber can be linked somehow so that when a new record is created in table 1, it will ensure that that number cannot be used in table 2?
For example:
If table 1 has 3 records, then the next record created in table 2 will have the autonumber 4, then if another record is created in table 1, it will have autonumber 5?
Thanks in advance for any help x
I have 2 tables, each have an autonumber as the primary key.
Different data will be entered into each table by different users and this all works fine.
But
On occassion, I will want to append the data for a record from tabel 1 into table 2. Currently this will cause a problem as it will create duplicate entries in the primary key.
Is there a way that the autonumber can be linked somehow so that when a new record is created in table 1, it will ensure that that number cannot be used in table 2?
For example:
If table 1 has 3 records, then the next record created in table 2 will have the autonumber 4, then if another record is created in table 1, it will have autonumber 5?
Thanks in advance for any help x