Hello,
I am working on a Directory and have trouble with a one-to-many relation within an edit form. We hare around 50 different Job Titles in our Dept, but these can be broken down into 10 groups. What I am trying to do is have datacard1 with a drop down in it that will have the 10 Title Groups. Once selected it will filter the 50 Titles in the datacard2 into the ones that only fall into that group. I am currently using a collection to create the relation between the Titles and Groups. Please let me know if it is possible to get this process working, or if I need to change or split the collection into two.
Collection Example
ClearCollect(
TitleCollection,
{Title: "Title 1", Group: "Group 1"},
{Title: "Title 2", Group: "Group 3"},
{Title: "Title 3", Group: " Group 1"},
{Title: "Title 4", Group: " Group 2"},
{Etc….},
{Title: "Title 49", Group: "Group 9"},
{Title: "Title 50", Group: "Group 3"}
)
Example of the desired results
