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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation rule build on other field in the same table 5
How do I use a table to validate data being entered into another 1
Define a default value from a different form 9
Validation of a field 3
Syncronizing data field from one table field to another table 1
How to validate time format from a text field? 2
Calculate field with input from different table 5
Data Validation 1

Back
Top