I'm working on project tracking canvas app based on Dataverse. I spent quite a lot of time figuring out how to design the table. What I would like to have is when user enter a project, when a category is selected, subcategory shows only subcategories related to selected category, again when subcategory is selected the next subcategory (level 3) to show only subcategories related to previously selected subcategory (level 2).
I'm not sure if this is the right approach but this what I tried. I have main table, let us call it Project with many columns including Category column which is a lookup column to another table CatList. In the CatList table I have three columns Level 1 Level 2 Level 3. In the canvas app, form and view of Project table I can see Category field with option of level 1. But how can I get level 2 and level 3? If I create level 2 and 3 fields in Project table how can I get those values in canvas app form. Thank you very much for any suggestions
