Add data to 2nd table after appending to 1st table

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

It's almost never either necessary nor appropriate to do this.

Creating an empty "placeholder" record with no data in it is pointless!

Just use a Subform and add data to the child table when it's needed; or run
another Append query if you're migrating data from someplace else. But there's
no point in putting in a record with only the ID.

John W. Vinson [MVP]
 
Back
Top