Why set field has ¶ sign

[Spidey]

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

[LaRetta]

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.