Comparing fields in two tables

[kankat]

The value of a field in my table is dependant upon the value of two fields in another table being eq to two fields in the current table.

Basically, if the record exists in another table I want to change the status for that coresponding record in the current table.

If Table1.PatientName eq Table2.PatientName and Table1.SerialNumber eq Table2.SerialNumber then Table2.Status eq "Shipped"

I'm not sure of the best way to go about implementing this logic and where to put it.??????

 

[plog]

I would write a query to calculate it and run that query whenever i wanted the data.

 

[kankat]

Thanks Plog!
I was headed in that direction but wasn't sure if that would update the existing records status value.