I have a database that tracks transactions from a number of accounts. Transactions are assigned to categories and subcategories. Due to the types and number of transactions the list of subcategory values is pretty lengthy. Is there a way to limit and display subcategory values based on the category value selected? In Filemaker I would do this by pointing the fields to a list that maintained the structure of possible values.