How to update the table

[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

 

[John Vinson]

how do i update a
table whene there is no unique fields

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.