I am importing lagacy data. I have imported the data using sqlBulkCopy the old data priamry key is a random number entered by the user so they are all over the place. The new tables auto generate the primary keys. I heed to link te two tables on a field containing the old primary key so that I can update the FK with the new PK. I have been looking at the BusinessLayerLinkManager but am not getting anywhere. Is that the way I should be doing this?

Ian, is this a data migration task (i.e. you're doing it or writing a script to handle it one time) or is this something the users need to do as part of normal use of the app?

This is a one time migration operation. Got it working using Ivan's suggestion.

Glad it helped, Ian.