BB Article # 105907 says.  "There is no mapped field between ON Product and The Raiser's Edge that contains a unique identifying number.  There is no means to query or identify the specific records in RE that are linked to a record in Core. The HOST ID does not sync to The Raiser's Edge. "  If there was a unique identifier, this would save so much problem.  No duplication, etc.