A lot of times you want to filter records WHERE FIELD1 = FIELD2, but in Navision this is not possible. You need to read all records and then select the ones you need. With the help of a flowfield in the table, this can be done:
Example table 99999:"TheTable":
10:"KeyField" : any type
100:"FIELD1" : any type
110:"FIELD2" : any type but the same as FIELD1!
130:"FIELD1=FIELD2" : boolean flowfield
CALCFORMULA:Exist("TheTable" WHERE ("KeyField"=FIELD("KeyField"),"FIELD1"=FIELD("FIELD2")))
If this this field is TRUE, FIELD1 and FIELD2 have the same value.
=> in short : the flowfield must first filter on its primary key so it finds itself AND it has also to filter the 2 fields I want to compare.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!