MS Access Help ???
I have a database that I created yesterday and started working on. I have 4 tables... blah blah blah
anyways... I decided the autonumber was not going to work for my primary key, so I switched it to a field I have labeled as JobNumber... the problem is I wanted everything sorted by the order that I put it in (i.e. the auto number) but isnce the switch on the PKey... now im stuck with it defaulting to sorting by the jobnumber field...
is there anyway to change that behavior?? I've looked and searched, All is to sort it by that? any ideas?