Create a value list from a check box field using a calculation field
I have a field called "Tag" set up as a check box, with values from a value list to assign a tag of for example "Caterer" or "Chef" or "Supplier" to a contact.
I have a calcuation field that gets its value from "Tag"
I use this calculation field to define a value list.
I have a text field in a related table called provider, which is set as a drop down list with the values from the defined value list
I have tried various IF and CASE statements but what ever I try I cannot get the calculation correct to show for example all contacts that have the tag caterer or the tag chef assigned to them. I can show contacts that are caterers or contacts that are chefs but if they are both (ie both values checked) the contact does not show up.
Any help much appreciated.