D
doglover
My database is changing data in fields with wrong
information and I am not exactly sure when this happens.
This is only occuring in one field and two tables are
involved.
table name field with problem
tblworkorders wrk_invno (primary key from tbl
invoice)
tblworkorders wrkno (primary key for this table)
tblinvoice invno(primary key for this table)
The wrk_invno is a one to many relationship (many on the
workorders side). When an invoice is created the
wrk_invno field is updated (automatically)with the invno.
The problem is that sometimes the system places the wrkno
in the wrk_invno field. I compact the database daily. I
have checked the code behind the form that creates the
invoice (invno) and see no errors. This did not start
happening until several weeks ago when we shut down our
server and disconnected because of a hurricane threat.
I thought about adding a field to the work order table
(tblworkorders) to track changes, to help isolate the
source and when the problem actually occurs. Any ideas??
information and I am not exactly sure when this happens.
This is only occuring in one field and two tables are
involved.
table name field with problem
tblworkorders wrk_invno (primary key from tbl
invoice)
tblworkorders wrkno (primary key for this table)
tblinvoice invno(primary key for this table)
The wrk_invno is a one to many relationship (many on the
workorders side). When an invoice is created the
wrk_invno field is updated (automatically)with the invno.
The problem is that sometimes the system places the wrkno
in the wrk_invno field. I compact the database daily. I
have checked the code behind the form that creates the
invoice (invno) and see no errors. This did not start
happening until several weeks ago when we shut down our
server and disconnected because of a hurricane threat.
I thought about adding a field to the work order table
(tblworkorders) to track changes, to help isolate the
source and when the problem actually occurs. Any ideas??