February 4, 201213 yr Hi, I am trying to figure out why set field has ¶ sign. In the output, the kf_OrderNumSelected column has only "1141" in the column for all records. Thanks. K.C. customer_ORDER::__kp_OrderNum & ¶ & CUSTOMER::_kf_OrderNumSelected
February 4, 201213 yr The ¶ sign represents the carriage return to FileMaker. So in your example, if __kp_OrderNum contained 36 and _kf_OrderNumSelected contained 21, the result would list as: 36 21 If you only have one value returned then it suggests that one of those two fields does not have a value ... or that the two tables are not related on that particular record.
Create an account or sign in to comment