I have two forms (A & B). Form A has the following fields:
Lot
Description
formula field combining the two fields Lot_Desc.
Decision box
Form B has a lookup to form A using the Lot_Desc field.
In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria?
for each x in Batch [Lot == input.Lot] worksfor each x in Batch [Lot_Desc == input.Lot_Desc] does not work
Herb Wexler