AnsweredAssumed Answered

Importing old data from Access and matching it to an existing ID in FM

Question asked by brian.curran on Dec 12, 2012
Latest reply on Dec 13, 2012 by brian.curran

Title

Importing old data from Access and matching it to an existing ID in FM

Post

     Hi,
     I have just imported approx. 4,000 records from an old Access database into a table called "Incidents", the old ID field format is "A.1230" so I created a Temp field with a "Middle ( OldID ; 3 ; 3 )" calculation to extract the "123" value.

     In an existing FM table called "SiteDetails", we have a unique SiteNumber field with the same format as the '123' value. I want to use this 'match' to tie the records together temporarily so that I can copy/retrieve the PK value from a related table called "Sites", how would I go about this?

     I'm not sure whether this will cause a problem or not but some of the imported records wont' have a match as their Site PK won't exist in the new FM database (old customers etc.)

     Thanks
     Brian.

Outcomes