"ID column". There's the rub. The BO to be updated is formally maintained in an MSAccess data base during a transition period. That will be at least a year, maybe more. The Access table maintains an ID. Would the AWAREIM BO accept that as the ID on import? The instances in the table are fairly constant with an addition every 3 or 4 months or so.
I'm thinking I need to create a temporary BO and use a
FIND A WHERE A.1 = B.1
B.2 = A.2
D.2 = A.2
type process