I have a main table tblPlants and wanted to populate several fields via listboxes. I used separate tables (e.g tblLightConditions, tblMoistureConditions, etc) rather than typing a value list. I want the values to show up in the listbox in a specific, but somewhat arbitrary, order. For example, I want the LightConditions listbox to show, in this order, Full Sun, Part Sun, Part Shade, Deep Shade. The best way I've come up with to do this so far is to have a numeric SortNumber field (which is different from the autonumber key), then use a query sorted on that as the row source for the listbox. Is there a smarter or easier way to do this? Maybe I should just type up the value list? Thanks for any advice.