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.