help imported data with ID field keeps re-ordering

[tizwaz]

I have data which was exported from a Filemaker Pro database and the table in question has an ID field. The ID relates to an incident number and needs to stay the same in my new Access database. I tried sorting it ascending and then adding a new ID field as an auto number but it through the records all out of order (well some of them). So I took that field off and tried to stick with the original number field for the ID but now even that is going out of order in the form. Only way I can keep incident 1 as the 1st record is to base my form on a query. Is there another way - I would prefer an auto number field going forward but can't get that to work and don't know why

 

[SkipVought]

Hi,

Relational tables have no order. Order By in your query.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MajP]

I have not tried it, but this should work. Create a new table in access with the same field names. The ID field could be an autonumber. Build an insert query sorted in the correct order you want to fill all the other fields. Run the insert query and the records should insert in the correct order.

I think the first method you tried should work, but you need to index the table on the old ID field and probably not have any other indices.