Unanswered: Controlling Cardinality of tables on the fly
I have two tables, Permits & Dogs - Permits linked one-to-many to dogs.
I need to be able to control the number of dogs linked to a permit based on a field (AnimalPermit) in the permit table. eg. If I have Pigs in AnimalPermit, then I can have up to 3 dogs, if I have Deer I can have 1 dog.
Also, is there anyway of being able to implement this functionality at Table level?