3 Replies Latest reply on Dec 3, 2008 8:18 AM by (rgnelson)

    Using Comma-Separated Selector

      I am building a site with products that can have different colors.
      Some products share colors.
      I am using the Comma-Separated Selector to select the available colors for each product from a list.
      My problem is showing each product and the colors available for each product.
      How do I create a recordset that pulls only the colors I need from the colors table based on the comma separated feild from the products table?
      Thanks for any help or point in the right direction.