I have two tables. In one of them there is a field named "Property ID". In the other one there is a field named "Account No". Both field are text fields.
Also I have a form bound to the 1st table. If there is a matching value in the 2nd table ("Property ID" = "Account ID") then I want a label to appear on the form indicating that there is a match.
How can I do this?