Filemaker internal SQL debug help
i am simply getting crazy on this one:
ExecuteSQL ("SELECT \"field1\" FROM \"table1\" WHERE \"field1\" = \"current_table::field2" " ;"";"")
Which means i want to see if there is a record in another db which is same as in the open layout database i am using this knob/function in.
everything works if i use '1' (records in field1 = 1) instead of current_table. But as soon i want to use current_table i get a "?".
I also tried a variable but absolutly nothing works there...
Please help, i amk allreaddy hitting the wall... :)