How can I include a field from another table in the validation ru.

R

Rafiotero

I need to subject the entries of one form to a validation that assures me
that the field being entrered is contained within another table in the same
database.
 
V

Van T. Dinh

Do you mean similar to a PrimaryKey in one Table and
ForeignKey in another Table? In this case, you can enfore
Referential Integrity between PK and FK.

Alternatively, you can use DCount() (or Recordset) to
check if the Field value entered exists in the other Table.

Check Access Help on the DCount() function.

HTH
Van T. Dinh
MVP (Access)
 
Top