Lookup Table Sort Sequence

[jrmbach]

I have a Table for Expenses. One of the fields “Vendor” is a Lookup Table. The Vendor Table has an AutoNumber field “Vendor ID” as the Primary Key. It also has fields for Vendor Name, Address, etc. I used the Lookup Wizard to create the relationship. I have sorted the Vendor Table by Vendor Name. When I use the Vendor field on Expenses Form, the Vendors are not listed by Vendor Name; they appear to be listed by Vendor ID. How can I get the Vendor Lookup list in order by Vendor Name?

[June7]

You have Lookups set in table? Advise against that, review http://access.mvps.org/access/lookupfields.htm

You mean you want to sort the expense records by vendor name? To sort by vendor name, must include Vendor table in query, join type "Include all records from Expenses and only those from Vendors that match"

[jrmbach]

How do I put a Lookup Table field in my Form if I should not put it in the Table for that Form?

[June7]

I just build combobox or listbox from scratch. I don't use wizards.