Thread: Validation Rule using data from linked tables...

Okay i am fairly new to Access so bare with me. I have created a split database for my dept at work.

I have two tables in my front end that are linked to the actual tables in the back end: [QA Route] and [Focus Techs]

I have created a split form called "Daily Route" that was created from the data in [QA Route].

Here is my question:

I have a column in [QA Route] named Install Tech and i have a column in [Focus Techs] called Focus Tech. In my form (Daily Route) i want to place a validation rule in a column called Focus Tech to do the following:

Return a "Y" if the data in [QA Route]![Install Tech] matches with a value in [Focus Techs]![Focus Tech].

Return a "N" if the data in [QA Route]![Install Tech] does not find a match with a value in [Focus Techs]![Focus Tech].

I hope this makes sense. I have tried using the expression builder, but haven't gotten anything to work.

Thanks in advance.

I would enter in the control source of the field. Something like.

Code:

=IIF([QA Route]![Install Tech]=[Focus Techs]![Focus Tech],"Y", "N")

Hope this helps,

Dan