AnsweredAssumed Answered

Test for related record

Question asked by Kaps_1 on Jul 10, 2013
Latest reply on Jul 10, 2013 by philmodjunk

Title

Test for related record

Post

     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.

      

BNI_CRM.png

Outcomes