J
JR
I am a first time Access 2002 user. I have developed a Contract DB that
automatically populates the Contractor information in the Contract and
Contract Details form from a primary key (contractor) combo box and also
contains additional information that requires entry (contract & contract
details). I have a command button at the bottom of the form that allows me to
add a new contractor if desired and another command button to refresh the
page that will re-populate the bound contractor info and continue the entry.
The problem however is, after the entry is complete, if I change the
contractor information at a later date, it automatically updates address
information, etc in the contract details form which makes the original
contract information incorrect. How do I prevent this from happening? I have
the Primary Key from Contractor (Autonumber Contractor ID) and Contract &
Contract Details (Foreign Key) relationship set one-to-many with referential
integrity and Cascade update checked. I have this cascading checked because
up to now, if I make a change on the Details form I would like it to update
the Contractor table, but not the reverse. I'm not sure if this is clear, but
would appreciate any light you can shed on this issue. Thanks. JR
automatically populates the Contractor information in the Contract and
Contract Details form from a primary key (contractor) combo box and also
contains additional information that requires entry (contract & contract
details). I have a command button at the bottom of the form that allows me to
add a new contractor if desired and another command button to refresh the
page that will re-populate the bound contractor info and continue the entry.
The problem however is, after the entry is complete, if I change the
contractor information at a later date, it automatically updates address
information, etc in the contract details form which makes the original
contract information incorrect. How do I prevent this from happening? I have
the Primary Key from Contractor (Autonumber Contractor ID) and Contract &
Contract Details (Foreign Key) relationship set one-to-many with referential
integrity and Cascade update checked. I have this cascading checked because
up to now, if I make a change on the Details form I would like it to update
the Contractor table, but not the reverse. I'm not sure if this is clear, but
would appreciate any light you can shed on this issue. Thanks. JR