August 8th, 2011, 08:17 AM
I have a database, of quite a size, one area of which logs all the company's tools.
When I created the list, then the subsequent form, I rather short sightedly neglected to sort the records into a 'logical' order.
Upon creating the form I didn't bother with a sort and therefore the records are sorted as per the primary key, which is 'Autonumber' - the trouble with this is that when adding new tools, of an identical nature to existing tools, the record appears further down the list, rather than with others of the same type (does that make sense?).
With the tables and forms already set, is there a way I can change the sort criteria, so instead of by Primary Key, I can change it to sort by Tool Primary number, then by Tool Secondary number?
All help and suggestions as ever greatly appreciated.
August 8th, 2011, 08:41 AM
Right - I have now sorted this matter - so all records are in order of the tool number.
However, an issue still occurs.
I have a drop box on the form for a quick jump to the record required, but it only sorts in order of the primary key, not by tool number - is there a way I can do this?
August 8th, 2011, 11:45 AM
the only way to obtain the order you want is through the use of an ORDER BY clause