Importing old data from Access and matching it to an existing ID in FM
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.)