table validation rule

[bjb123]

I have a customeraddress table that has a [customerID] and a [default] yes/no field.

A customer must have 1 and only 1 default address. But a customer may have zero to many non-default address. Seems like a good place for a table level validation rule. But I can't figure out how to get it to work with a dcount, or dlookup.

I could always write code to validate this on the form, but I would really like to know how to write it in the table if it is possible.

 

[PHV]

The help about ValidationRule clearly states that you can't use any domain aggregate function in a table level validation rule.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bjb123]

doh! I was on that page most of the morning but somehow overlooked that sentence.

Thanks. That actually saves me a lot of additional wasted time trying to figure this out.