Hey all,
New to Dataverse and I've got a seemingly simple task I'd like to accomplish but have yet to be able to do it.
Essentially I want to have two choice columns. Column A = Group. Column B = Sub-group.
Is there a way to have the second column (subgroup) be filtered by the group that it belongs to?
My initial idea was to create a lookup table however I didn't get very far with it.
Any advise is more than welcome.
Hi @CameronTCD ,
Create two tables for Group and Sub-Group with a 1:N dependency (add Group to the Sub-Group table). You can then add the Group and Sub-Group to your target table as two columns and utilize the capability to filter your sub-group based on your selected group in the Form setup for these two fields. To do this, follow steps.
User | Count |
---|---|
20 | |
11 | |
9 | |
5 | |
5 |
User | Count |
---|---|
34 | |
32 | |
18 | |
18 | |
7 |