Auto Number/number

[HelsBels]

Hello

I have got a database that has got a few different tables in it. The first table consists of a list of all records with contact names, telephone number, address etc. I have allocated an auto ID number to this field so that it has a unique ref. I have done a few update queries on this table - i.e de-duping against telephone number etc. I've then appended this table to another table called main. I've changed the main table iD from auto number (in first table) to number in the second table. I've then done another append to another table called dialler. This table is in the specified format for our dialler (the data is going to be loaded on to our dialler for calling). However, when I append the table main to the table dialler all the id numbers get jumbled up and don't represent those in the main or first tables at all. I don't understand why it is doing this as it appends ok from the first to the 2nd table, but not the 3rd????

Does anyone know why the id field (i.e a number) would change itself when I run an append query?

Thanks

 

[jeremie_ingram]

This could be a result of sort order. In the last query, just set the sort order under the ID and it should come up in order.