P
pepenacho
Hello:
I have a form that is mapped to a qry. The qry is based on two tables. The
join between the two tables has ref integrity established, with both
cascades. It's a one-to-many relationship.
When I update informatation for a record (i.e. the field that is also the
key for one of the tables - the one side of the join), I get a write
conflict. If I take the "save" option, the changes are saved in both tables.
How do I get around that write error and what could be causing it?
I'm running Access 2000. I'm thinking about using a piece of code that would
run
DoCmd.RunCommand acCmdSaveRecord
each time an object in the form change - b/c saving the record seems to be
the issue.
Any ideas?
Thanks,
pepe
I have a form that is mapped to a qry. The qry is based on two tables. The
join between the two tables has ref integrity established, with both
cascades. It's a one-to-many relationship.
When I update informatation for a record (i.e. the field that is also the
key for one of the tables - the one side of the join), I get a write
conflict. If I take the "save" option, the changes are saved in both tables.
How do I get around that write error and what could be causing it?
I'm running Access 2000. I'm thinking about using a piece of code that would
run
DoCmd.RunCommand acCmdSaveRecord
each time an object in the form change - b/c saving the record seems to be
the issue.
Any ideas?
Thanks,
pepe