How to update the table

  • Thread starter Thread starter subbu
  • Start date Start date
S

subbu

Hi,
I am using the append query option to insert into the
table.I want to update the inserted row with another value
which is not part of the append query.How do i track which
row the append query has inserted or how do i update a
table whene there is no unique fields

regds
subbu
 
how do i update a
table whene there is no unique fields
Click to expand...

You can't. That's why in proper relational design every table must
have a Primary Key, consisting of one or more fields which uniquely
identify the record.
 
Back
Top