import from table and transfer relationship
Ok so... i've checked a lot of documentation but nothing seems to answer the specifics of my circumstances (either that or it's worded in a way that i'm not connecting) and i'm not sure how to resolve...
Forum Discussion
UPDATED ANSWER:
Hi Vincent,
The easiest way is as you have done, export both tables, import the parent mapping your old record id or key field to a field (named old record ID or something), then export it again then then do a match and index formula in excel to map the old field to the related record id in the child table record an return the new record id.
Then import the child records again with the child record id mapped to an old version field.
Hide the two old record id fields from your forms, default report settings etc., but they will be there should you want to investigate any mapping issues down the line.
Jack
Hi Vincent,
The easiest way is as you have done, export both tables, import the parent mapping your old record id or key field to a field (named old record ID or something), then export it again then then do a match and index formula in excel to map the old field to the related record id in the child table record an return the new record id.
Then import the child records again with the child record id mapped to an old version field.
Hide the two old record id fields from your forms, default report settings etc., but they will be there should you want to investigate any mapping issues down the line.
Jack