AnsweredAssumed Answered

creating multiple lists from one features table

Question asked by hokiemike64 on Sep 20, 2010
Latest reply on Sep 20, 2010 by philmodjunk


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