Displaying SubCategories in a categories field
Posted on 2002-04-19
I have created a categories field and I am able to create subcategories by using the '\'.
I am using a formula to create the list of choices for a categories field. This formula does a dbColumn lookup from a view called "By Category". Here is my formula currently:
@Unique(@DbColumn("":"nocache"; ""; "By Category"; 1))
This formula only returns a list of the highest level categories, but does not list the subcategories. Can I create a formula that will return the subcategories as well?