Hi all!
I want to sort the records descend according to the time they are added (i.e., the youngest first).
I know that there are more sophisticated ways to do so (combination of date and time), but I would like to sort by the ID number (automatically tracked). However, dbman cannot sort by field nr. 0 (this is what one former posting said and I made the same experience). Therefore, I thought that I could set the ID to field 1.
However, I remember that "somewhere out there" somebody said that the ID should be in field nr. 0.
My question: Do you think it can cause any serious long-time problems if I use field nr. 1 for the ID field and nr. 0 for any of the other fields (until now the test-database works fine)?
Thanks and all the best,
Michael
I want to sort the records descend according to the time they are added (i.e., the youngest first).
I know that there are more sophisticated ways to do so (combination of date and time), but I would like to sort by the ID number (automatically tracked). However, dbman cannot sort by field nr. 0 (this is what one former posting said and I made the same experience). Therefore, I thought that I could set the ID to field 1.
However, I remember that "somewhere out there" somebody said that the ID should be in field nr. 0.
My question: Do you think it can cause any serious long-time problems if I use field nr. 1 for the ID field and nr. 0 for any of the other fields (until now the test-database works fine)?
Thanks and all the best,
Michael