Cross Table Validation

[Guest]

Is there way to control that field from X Table or Form does'nt equal to any
row value of other field in Y Table or Form. How can we place validation rule
and in which we should define at table level or form level.

 

[Van T. Dinh]

Besides Referential Integrity, I don't think JET provides any other
cross-Table validation check so I think you need Form Event to check the
required validation.

My guess is that you need to use the Control_BeforeUpdate Event of the
Control which is bound to the Field that needs to be checked.

 

[Guest]

Perhaps a JET Check Constraint would work for this situation?

How to Create a Jet CHECK Constraint
http://support.microsoft.com/?id=201888


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Besides Referential Integrity, I don't think JET provides any other
cross-Table validation check so I think you need Form Event to check the
required validation.

My guess is that you need to use the Control_BeforeUpdate Event of the
Control which is bound to the Field that needs to be checked.

--
HTH
Van T. Dinh
MVP (Access)
__________________________________________


Is there way to control that field from X Table or Form does'nt equal to any
row value of other field in Y Table or Form. How can we place validation rule
and in which we should define at table level or form level.

 

[Van T. Dinh]

Thanks, Tom.

I forgot about those new features of JET 4.0 that are not exposed in the
Access GUI.

Personally, I still use the Form for validation in this case, though.