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.
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.