2 Replies Latest reply on Jun 1, 2012 10:32 AM by GuyStevens

    Create a value list from a check box field using a calculation field

    ElizaBruml

      Title

      Create a value list from a check box field using a calculation field

      Post

      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.