I have two files, seperate databases, each containing information about people. The largest file has 100,000 people in it and the other file has only 445. I want to update the old file (445) with new addresses from the larger file. I want to match addresses to see if they've changed and replace them. I'm new to FMP and am going round and round with the manual to try to figure this out. Is there a relativley easy solution?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating similar files
- Thread starter rickshaw
- Start date
I presume you have a key linking the two files? If not, you need to create one. Depending on how you have created the files, this could be a simple serial number. Alternatively, use a calculation field consisting of -
FirstName & " " & Second Name & " " & Last Name & " " & Telephone Number
That should go close to being unique but would need checking.
I wouldn't worry about checking if the addresses are different. Just do a Replace -
Replace AddrLine1, NewFile::AddrLine1
Replace AddrLine2, NewFile::AddrLine2
and so on for every address component.
This will not be fast but should be bearable.
HTH
Cheers,
Paul J.
FirstName & " " & Second Name & " " & Last Name & " " & Telephone Number
That should go close to being unique but would need checking.
I wouldn't worry about checking if the addresses are different. Just do a Replace -
Replace AddrLine1, NewFile::AddrLine1
Replace AddrLine2, NewFile::AddrLine2
and so on for every address component.
This will not be fast but should be bearable.
HTH
Cheers,
Paul J.
- Status