Replace from related table inserts blank when no matching record exists

[cbum]

I'm using replace field contents to update an "ID" field by getting it from a related table (related by other identifiers) that has the new ID.

That works fine, except that it replaces the field with a blank in cases where the new table has no matching record. Is there a way to avoid that?

 

thanks

 

Edited June 15, 2015 by cbum

[eos]

Put the related ID field on the layout and perform a find for "*"; then perform RFC for the found set.

Alternatively, use this calculation

Case (
  not IsEmpty ( RelatedTable::IDField ) ;
  RelatedTable::IDField ;
  LocalTable::IDField // the RFC target field itself
)

as RFC result for the total record set.

[cbum]

Thanks!

(facepalm & blush...)

 

;-)