Deleted some data in Table, now form is missing half of the data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB. I
have tweaked this DB to work for our small co.

It has worked pretty well up until I made the mistake of deleting about 80
records from the Orders table. 80 out of a 1000 records.

Now our data entry form shows our customer addresses, but not customer order
history. When looking at all of the tables, customer, payments, orders, they
still have all of the current data. I tried putting the deleted records
back, but this had no effect on the form, it's still 1/2way blank.

What did I do? What can I do to fix? I am not a programmer and this has
worked fine for us that last few years. Anyone's help would be appreciated.

Thanks.
 
Back
Top