I'm trying to come up with a way to allow one column to have the same value up to two times, but no more than two times. I attempted adding a constraint to check the count of the value in the field - count (trsqqq) <=2 but aggregate functions are not allowed in constraints. Is there another way to do this? Any help would be greatly appreciated.
Thanks in advance.
Dara
-- Dara J. Olson Unglaube
Aquatic Invasive Species Coordinator, Spatial Database Manager Great Lakes Indian Fish & Wildlife Commission P.O. Box 9, 72682 Maple Street Odanah, WI 54861
