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.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Kevin
    • Kevin
    • 1 yr ago
    • Reported - view

    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

Like Follow
  • 1 yr agoLast active
  • 1Replies
  • 325Views