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 |
---|---|
18 | |
15 | |
14 | |
10 | |
8 |
User | Count |
---|---|
39 | |
30 | |
23 | |
21 | |
16 |