Append Query - without sort

[SalesOp]

Hello,

In an append query with a Key field I find that the records seem to be automatically sorted on the Key field. They get inserted in between the records. I would like the new records to be appended to the bottom of the table. I have tried to look into the table sort orders but couldn't figure out how to do this. I would appreciate any help on how this can be done.

Thanks

 

[JHB]

Does the table you append the data into have a key field?

 

[SalesOp]

Yes it does have a Key field.

 

[JHB]

Then the records get sorted according to the key field.
Only way is to remove the key field.
But why is it important for you to append the records in the button of the table?

 

[stopher]

Hello,

In an append query with a Key field I find that the records seem to be automatically sorted on the Key field. They get inserted in between the records. I would like the new records to be appended to the bottom of the table. I have tried to look into the table sort orders but couldn't figure out how to do this. I would appreciate any help on how this can be done.

Thanks

Tables don't have any sense of order. When you add records to a table then are all just one big pot of records - no order as such, regardless of the order in which they were added.

You apply order using fields. The primary key will provide one order. But you can order on any field. So if you add a timestamp field which logs when the records was added then you have a field with which to order by date added.

 

[SalesOp]

I am appending employee hierarchy and each append is the next level manager. I did not want to create another field for the manager level but I guess I don't have much of a choice.

Thanks for your support