Isssue description:
I am looking up a text field (DefaultOrderType) in the Orders table from the Suppliers table, based on a number (SupplierID).
In the Suppliers table the DefaultOrder type is "n" characters long (e.g. 6 chars, "IN-OUT")
In the Orders table the looked-up DefaultOrderType will be n+1 characters long (e.g. 7 chars, "IN-OUT¶") – thus a carriage return [ char(13) ] is added during the lookup.
I believe this is some unexpected behaviour.
texas0478:
Thank you for your post.
I am unable to replicate the issue. I have enclosed a sample file that looks up the DefaultOrderType text field from the Suppliers table based on the SupplierID number field. Let me know what I am doing differently than you.
TSGal
FileMaker, Inc.