AnsweredAssumed Answered

finding 2 records of 2 table with the same field's Contents

Question asked by Atefe on Sep 26, 2016
Latest reply on Oct 20, 2016 by Atefe

Hello everybody!

 

I use FM 13. I have two table in my database and i have related them to each other with their "Field1".

In order to find two match records (2 records of 2 table with partly same field's Contents), I have create a calculation field in one of those tables with this function:

If ( Table1::field1 = Table2::field1  &  Table1::field2 =  Table2::field2; "√"  ; "x")

 

But unfotunately that does not work What is wrong with my function?

 

I thank you all in advance!

 

Warm regards,
Atefe

Outcomes