AnsweredAssumed Answered

Crosschecking External File

Question asked by icelille999 on Oct 3, 2013
Latest reply on Oct 4, 2013 by philmodjunk


Crosschecking External File



     I'm quite new to Filemaker and scripting. I'm having an issue with having the ability to create something for me which would cross check 1-2 specific fields in a certain records that have different certain codes in an external file. I attempted to create some sort of solution by creating a calculation field, with the following inside: 

     In Kit =


     If ( Inventory::Manufacturer Part Number = 2::Vendor Part Number; 2::Assembly Number ; "false")


     With that, the only solution I ever get is false.. but I double checked the names and how to format an if command, and it's still wrong. I even tried importing the records into a different table in the same file, but still.. nothing. If someone could please point me to the right direction somehow and help me figure this out, I would be very grateful.