No offense, but that won't work as I need to build the various footnotes. It's not a one-for-one.

>No offense, but way too much code for a simple job. Mike Yearwood showed you one solution, I prefer this variant

>select targettable
>set order to targettag in sourcetable
>SET RELATION TO sourceexpression into sourcetable
>REPLACE all field1 with sourcetable.field1 for !eof('sourcetable')

>
>>I ended up doing this which works fine, but I really would have like to use the UPDATE. Some day...
>>
>>

>>
>>SELECT iAccts
>>SCAN
>>	SELECT crsFundAcctDisc
>>	LOCATE FOR crsFundAcctDisc.Acct_ID == iAccts.Acct_ID
>>	DO WHILE .T.
>>		IF FOUND()
>>			REPLACE iAccts.FootNote WITH ALLTRIM(iAccts.FootNote) + '('+ ALLTRIM(STR(crsFundAcctDisc.FootNote))+')'
>>			CONTINUE
>>		ELSE
>>			EXIT
>>		ENDIF
>>	ENDDO
>>	SELECT iAccts
>>ENDSCAN
>>
>>