I need to organize a list of sites into "routes" to be visited throughout the week. Site 101 would be the first stop on Monday, Site 201 the first on Tues., etc.
What is the easiest way to populate a combobox with a list of available route numbers?
I already have a dataset of the sites with RouteNum as one of the fields (but not sorted on this field). Is this of use, or do I need to requery the database to find which numbers have already been taken?