AnsweredAssumed Answered

How to Limit Number of Records Associated with Specific ID

Question asked by dtwalsh on Feb 9, 2017
Latest reply on Feb 9, 2017 by philmodjunk

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.

Outcomes