Question

[EAB1977]

Hi All,

I have created a database that stores information about gauges/items
within our company and tracks it's location, whether the item has
changed location, is in a repair state, being calibrated, on loan to a
different department, etc. When a user updates a serial number
(currently we have generic serial numbers and are putting the correct
serial numbers in it's place) the serial number changes and the data
is saved to the database.

My database has many relationships to keep the data integrety(sp) in
check. The problem I am having is that once the user has changed the
serial number, saves the data, and then goes into a existing repair,
the I get a error 92.

I wonder if someone has had this same experience and has found a
solution. I am using Access 2007 software with the program written in
Access 2003.

 

[PieterLinden via AccessMonster.com]

Do you have Cascading Updates turned on? If not, you're going to orphan all
the child records of whatever item you're updating.

 

[EAB1977]

I do have the updates turned on.