Updating Records

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

Guest

I have table that has 40 records. I am using autonumber to give them unique
keys.
My problem is that these are records that contain information that needs to
be updated and a new record added with the updated information to the table
with different autonumber.
 
My problem is that these are records that contain information that
needs to be updated and a new record added with the updated
information to the table with different autonumber.
Click to expand...

So what is the problem?

Tim F
 
Although the structure doesn't seem "normal" I assume you mean that, if
someone updates a record, rather than them actually updating the current
record you want a new record to be created? Do you want the 'obsolete'
record to continue to exist?
 
Back
Top