Check 3 tables have used same Contact ID
Posted on 2014-01-06
I use Access 2010.
I have 3 tables that hold a lot of information but all 3 of these tables has a field called ContactID.
I would like to know how I can check if the same ContactID has been used in tbl1, tbl2 & tbl3. Basically, if the same ContactID has been used in all three of these tables, I need to display within a text box within a form, a message to show the total number that are complete. If the ContactID has only been used in tbl1 & tbl2 for example, then it would not take this into account as all 3 tables need to have the same ContactID in order for it to be complete.
Hope this makes sense.