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.