I have a view called (Users By Group) - the view is setup like this
Group User Email
Owner Bob Roast email@example.com
Worker Chuck Cheese firstname.lastname@example.org
ETC.. etc.... etc.....
I have a field in my form called GroupSelect (Checkbox) Values= Owner
Then I have SendTo field
I would like for when GroupSelect = Owner - the SendTo field is set to dialogbox and shows all the users created in the database but only the ones in the owner group are checked - this would work for any selection and if all is selected all names are checked.
I was trying to use this as the default for SendTo
result := @Name([CN];@DbLookup("":"NoCache";""; "(Users By Group)"; GroupSelect; "Username"));