Could I somehow use the & command for the following?
As you can see, I have 2 tables and multiple fields which all have the same prefix.
I appreciate the assistance.
Code:
** "tcType" could be "pick" or "drop"
** the following is kind of pseudo-code
REPLACE first.tcType+"name" WITH ALLTRIM(second.name) ;
,first.tcType+"address1" WITH ALLTRIM(second.address1) ;
,first.tcType+"address2" WITH ALLTRIM(second.address2)
IN "first"
** There'll be additional "FieldName1 WITH eExpression1", but you get the idea
I appreciate the assistance.