3 Replies Latest reply on Feb 9, 2017 8:37 AM by philmodjunk

    How to Limit Number of Records Associated with Specific ID

    dtwalsh

      I'm creating a database that tracks up to eight attributes (of more than 30 available in a value list) per a certain product. The order in which an attribute is added is not important. I have a unique serial number (key) for each record in the table, but I'm not sure how to allow only 1-8 separate attributes for each product ID. Basically, I'm trying to ensure that if a product already has 8 attributes the 9th would not be permitted.

       

      Thanks for any help you can provide.