If tables match adding value n field

[amerifax]

I have two tables
Permit
PermitTest

Both have a field, column, called seal. if they match I have another field in Permit called "SealMatch". this is what I'm trying to do.

Permit-> Seal linked to PermitTest->Seal
If PermitTest->Seal exist in Permit than Permit->SealMatch should be yes, Yes & No field.

I'm trying to do this using the QueryDesign Access 2013.

Bob

 

[amerifax]

I've tried several ways to match two Tables with no luck. So I changed my thoughts a bit:

Permit->Seal (also contains a field called "SEQNO")
SealCHK->Seal (also contains a field called "SEQNO" which are all empty fields currently)

If Permit->Seal = SealCHK->Seal than SealCHK->SEQNO should receive the value that is in Permit->SEQNO (which is an alpha character value)

All fields involved are of the same type and size. I'm hoping to get some help . I might also mention that I work best using the query design rather than code which I don't much understand.
Bob

 

[amerifax]

I was able to get a solution using Microsoft community my answer.

UPDATE PERMIT INNER JOIN WICHK ON PERMIT.seal = WICHK.seal SET PERMIT.[WI-WI] = "okay", WICHK.[WI-WI] = "okay";

I will bit surprised. AccessWorld used to be the top-of-the-line. Maybe I just didn't explain myself as well as I should have. But for those people that have a similar problem the above code works fine.

Bob

Sidebar: The above code also includes a couple of expansions ,okay, to my issue.