sort related value list
I have an Invoice database. The Products are listed in the Invoice table from related records in Products table as a drop down list which automatically sorts by alphabetical name. I want it to sort in a custom order since there are dozens of products. How do I do that?
Also how do I add an "other" option to that list?