1 Reply Latest reply on Sep 20, 2010 9:22 AM by philmodjunk

    creating multiple lists from one features table



      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?)