Hello everyone,
I have an employee database that stores the usual information. I’ve created Phone and Email sub forms because we need to track all employee phone numbers and email addresses—both personal and work-related. Some employees have multiple phone numbers and multiple email addresses.
In these sub forms, I use combo boxes that allow the user to select the type of phone number or email address. The issue I’m having is that I want to sort the Phone Type and Email Type so that work-related entries appear first, followed by personal ones. For example, personal email addresses should appear after work email addresses.
A bit more background on my database: for my combo boxes, I followed Richard’s advice and created separate “List Tables” to serve as the data source. Each list table includes a “Sorting Number” column so I can control the order of the items.
As always, any help would be greatly appreciated!