Updating a record in two tables with values from text boxes on a form

pnmng49

Registered User.
Local time
Yesterday, 19:11
Joined
May 31, 2008
Messages
16
Hi everyone,

I have two tables with a one to one relationship (they have the same PK). I would like to be able to update the record in each table from values the user inputs into text boxes on a form. I have set "referential integrity" and "Cascade updates", but the update is only happening in the first table. Any help would be appreciated.
 
If you want to UPDATE a record in another table, it means that the record in this table alredy exists. I think you need to Append a record in another table.
In that case use an APPEND QUERY in Sub After_update (in your form).
 

Users who are viewing this thread

Back
Top Bottom