For example, let's say I have a comments field for unique record 1234. Let's say that it has "XXX" stored in the comments field for that record. Later on I'm going to import a file using the "Update matching records in found set" option. The imported file contains a matching record that has "YYY" stored in its comments field.
As of right now, FileMaker will simply update the field with the new comment. This overwrites the "XXX" comment. I want to append the "YYY" information to the comments field instead of updating/overwriting.
Is this possible? Any advice/suggestions are appreciated!!