Different sorting on Temporary and Normal Tables in Navision

Last week I had a problem with a client witch was that the export of dimensions on analysis view was wrong. After a lot of research I found the following detail. Navision sorting on Code field is different when the table is normal and when the table is temporary.

Lets say that we have a table with a key field (ID => Code 10). If we insert into table values ‘1000’, ‘1000-1’, ‘1001’ and we open the table we will see the following sorting

1000

1000-1

1001

If we create then a form with SourceTableTemporary = Yes on form properties

and insert the same values, the sorting will be like this

1000

1001

1000-1