Updating values in a field

  • Thread starter Thread starter John
  • Start date Start date
J

John

Having a little glich in my database. Using Access 2000.
When pricing changes from my vendors I update previous
records so I am not reflecting actual spending. I don't
want my previous records to update. Have tried unchecking
cascade update records but doesn't seem to have any
affect. Any suggestions?
 
I would suspect you have table structure problems, or you are not storing
your data in the proper tables. Your vendor pricing should most likely NOT
be linked to your stored pricing, as this will change (as you are seeing
now) ... these are two separate pieces of data which will quite often be
identical and which should be stored in two separate places. If you post
your basic table structure, we may be able to help more easily.
 
Back
Top