Nested Dynamic Lists
I'm trying to add the ability to attach a category and sub-category to a record. These lists of values need to be dynamic, so I am making use of the Choice (dynamic) field type. The category popup populates just fine, but I'm not sure what my query should be for sub-category. To clarify, category and sub-category are related tables; I associated sub-categories with their parent category creating a hierarchy. Any suggestions on what my sub-category query should look like? From what I understand, it basically needs to query the sub-category table where its category (reference) equals the current record's category name. Thanks for any help with this.
1 reply
-
OK, after some trial and error, I got something working. For others that may need to do this, here's the code I'm using:
let cat := text(Category);
select Subcategory where Category = cat
Content aside
- 3 yrs agoLast active
- 1Replies
- 351Views