- Local time
- Today, 12:21
- Joined
- Oct 29, 2018
- Messages
- 21,473
Well, you know what? If Titles is a lookup table, then the ContactTitle field in the Contacts table should have been a Foreign Key to the Titles table. If so, you would have been storing the ID field in it, and therefore be able to sort by it.This I know, If I enter [ContactTitle] in the OrderBy property, it sorts them alphabetically. Would I would like it to sort by is the TitleID of the associated title so instead of sorting the table as
Capt
Capt
Dep
Lt
Lt
Sgt
it would sort it based on their ID from the titles table and would look like
Capt
Capt
Lt
Lt
Sgt
Dep