Test for related record
I have done this several times and gotten this to work but I cant this time.
I have two tables called "Companies" and "Holding Area Active Members".
In my "Companies" table, I have two fields Companies Id, and Company.
In my "Holding Area Active Members" table, I have a field called Company name.
The relationship is:-
Companies::Company = Holding Area Active Members Table:Company Name
I am trying to identify which company names in the holding table are already in the Company Table. I have posted my script in the next post below.