creating multiple lists from one features table
I have a simple table that has a featureID, LocationDesc and FeatureDesc fields. This table is related to a location table that has locationID and Location Description. The location description is tied to location ID in the related table.
What I want to do is create several check boxes for various features, based on their locations. I cannot seem to create a list that basically says Select * from Features WHERE LocationDesc = "Interior"
Is there a way to create a list by subselecting a table's contents, or would I be better off just creating three tables (and additional tables for each new location as the future provides?)