HELP Validation from a 2nd table or from a query output

[TEJohnson]

I have 2 Front Page forms that submit info to 2 Access tables and I want to
have a validation rule that
either uses the output of a query or uses the info from the second table...Is
that possible.

Table1 is called Results_Adjuster with column headings of "Adjuster" "Date"
and "Status"

Table2 is called Results_Assign with column headings "Claim Number" "Desk
Code" "Assignor" and "Date"

Query2
SELECT [Results_Adjuster].[Adjuster], Max([Results_Adjuster].[Date]) AS
MaxOfDate, Last([Results_Adjuster].[Status]) AS LastOfStatus
FROM Results_Adjuster
GROUP BY [Results_Adjuster].[Adjuster]
WITH OWNERACCESS OPTION;

I need "LastOfStatus=Active" to be my validation for a field in Table2 or I
need to create a validation rule in Table1 that generates the same result as
Query2 and then put a validation rule into Table2 that looks at Table1...Not
sure how to accomplish this???