here is the tip to create an
update query.
You seems to be familiar with delete and append queries. To create an update query, create a new query, select the query type as update from the menu, include the table to be updated to the grid and drag and drop the autonumber field to the first...