From Dwayne Wright PMP
Certified FileMaker Developer
Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit. For the best experience, please visit the journal directly by clicking (here).
Recently I have been working with a lot of databases that have been without the comforting touch of a FileMaker developer in a very long time. Although I’ve seen this again and again, I’m still amazed about how FileMaker databases and FileMaker servers can run for many years without any maintenance. Of course, that isn’t the way it should be but it is comforting to know they are so solid!
Anyway, I was combining some database files together that center around the same business unit. These tables referenced a country code file that was badly damaged and the server wouldn’t open it. I have no idea how long this has been the case, the users were simply closing the “File Not Found” dialog box every time it would arise.
According to wikipedia ... Country codes are short alphabetic or numeric geographical codes (geocodes) developed to represent countries and dependent areas, for use in data processing and communications.
I remember that there are country code databases and export files out on the interwebs and did a quick google search. When looking for such things, I tend to put “FileMaker” as a key word on my first search pass because you never really know!
In the middle of my search results was a custom function from the library found on briandunning.com and I thought this was an excellent alternative to maintaining a table within each file that leverages country code options.
Here is a link if you are interested (click here)