Adding records with referential integrity

[dtutton]

Can one use rferential integrity to add a record to two tables? I have tested with delete and it works fine but cannot get to add a recod to both tables ?

David

 

[ghubbell]

Hi David,
No sir. You can get it to update an existing record but not add. If you work off a form, in the after update event of the "connecting" field, after first saving the record, have it run a query that appends the same value to your other table. Something like:

On Error GoTo err1
DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfYourQuery"

Exit1:
DoCmd.SetWarnings True
Exit Sub

err1:
MsgBox Err.Description
Resume Exit1

should do! Gord
ghubbell@total.net