Importing legacy database into new database

[Jeff Abraham]

I have FileMaker 5.5 dilemma. I have an old database system that I need to merge/import into a new database system. The basic issue is that the older database uses a different relationship than the new system. The relationship is one-to-many.

When a record is created/imported into the new system, an auto ID is created called 'IDWebJobs'. The old relationship is based on a field called 'SpecCode'. The question is when I import the old records into the new system and the 'IDWebJobs' field is auto-populated, how do I change the other related database to match these new ID's without manually entering in the new ID's? Is there some type of script/calculation that I can create that finds the new IDWebJobs ID based on the old SpecCode and matches that to the related database?

[Fitch]

If I'm understanding you correctly, simply do a Replace on the IDWebJobs field in the "many" file with a calculated result: SpecCodeRelationship::IDWebJobs.

[Jeff Abraham]

That should do it. It's been awhile since I've had my FileMaker brain turned on. Thanks!