KC wrote:
I am using Access 2002, with a database template from MS Office. The
Orders Management Database. I have tweaked this for use with our
company. It is a small database with close to a 1000 records in our
Orders table. Within this table are 80 records that I decided to
delete to clean it up a bit. When I went into my data entry form, I
noticed the bottom portion of the form was blank, this is usually the
area that contains each customers order history. The top portion was
fine, this is customer address info.
When looking at the customer, order and payment tables, all of the data
is still there, but it's the form that is now not working properly. I
have tried pasting the deleted records back into it's original state,
but that doesn't do anything.
Can anyone tell me what I did wrong? Plus, is there a way to repair
the form so I can see the customer order history in the form again?
P.S. I am not a programmer. Was able to play around with it for a few
years, but now it looks like I played with it a litte too much.
Thanks,
Kim.
Kim, it sounds like there is a one to many relationship. And from your
description it appears this is a MainForm/Subform problem. For example,
the Mainform presents your customer info and the Subform presents the
order history. Usually there is a field that links the two tables
together...for example an OrderId.
It's quite possible that OrderID may be an autonumber field (check the
tables in question used in the Recordsource of the forms). So lets say
you put back the deleted record. It will now have a new OrderId field
number (because it is an autonumber) and those records in history have
nothing to link to (it's pointing to an autonumber that no longer exists).
What you need to do, if this is an autonumber field used in linking the
two tables, is recreate the deleted record and find the associated
history records and update the link field in the history table
If you have hard copy of the orders, you may be better off simply
recreating the orders. It's work, I know, but it may be quicker to
re-input than fuss with this.
If you decide to do some fussing, I highly recommend you check out
FindUnmatched queries...go to the Query tab, press New, and select
FindUnmatched. This way you can find out with OrderHistory records have
no matching Order record or visa versa.