text: 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.
  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
  - 3 yrs agoLast active