I have 2 datasets and a table repeater. I want to filter the first dataset by a second filtered dataset. First dataset (main) is a list of club members with a multi-reference field for their Role. The role can be member, president, treasurer, chair, etc. A member can have more than one role so I used a multi-reference field.
My second dataset is the club role dataset. I filter it to include every role that is not ‘member’. I used several filter options like ‘Is Not’ Member, or ‘does not contain’ Member, no success in returning all records without role ‘Member’. I should get president, vice president, etc, but no ‘Member’ roles. Next, I change the main dataset of members to filter using the filtered Role dataset, When I do this, I only get one member returned in my repeater elements. The role returned is the first row it returns where the role wasn’t ‘member’. (I think that’s what it’s doing)
I wanted all members who do not have the role of ‘member’ to be returned to the repeater elements, but I only get one member returned.
Interestingly, if I change the member role dataset to select only the role ‘secretary’, I get two member rows returned, which is correct because their are two secretaries,
How can I get all member records returned who do not have a role of ‘Member’?
What have I messed up? This is a new account using Wix Studio)
thanks. Mike