G
Guest
I have an append query to add records to table 1. This table has an ID field
set as AutoNumber. When records are appended to table 1, I need the
AutoNumber to be added to a second table. The second table has a field named
ID and it is a Number field.
I've set Referential Integrity with Cascading Updates and Deletions.
However, I can not get Table 1 ID # to auto populate into Table 2. How is
this accomplished?
set as AutoNumber. When records are appended to table 1, I need the
AutoNumber to be added to a second table. The second table has a field named
ID and it is a Number field.
I've set Referential Integrity with Cascading Updates and Deletions.
However, I can not get Table 1 ID # to auto populate into Table 2. How is
this accomplished?