Use contents of zip code field to populate county field
I apologize for my newness to Filemaker and if this questions has already been answered on this forum! Hopefully I'll be able to explain my situation: I have a table (Person Info) with zip code field. We'd like to capture county information based on those zip codes.
I've uploaded a zip code/county table (Zip Lookup) and have created a relationship between the Person Info and Zip Lookup tables, and set the county field to populate with the info from the Zip Lookup table. It works like a charm when I type in the zip code.
But there are several records that already have the zip code field filled (previously completed before I made the Zip/People relationship), but the county fields remain empty. I suspect I'll need to write a script to look up the rest of our records' zip info on that Zip Lookup table and then enter the corresponding county.
Would someone be able to help me with this? Like I said, I'm extremely new and have very little programming experience (though I understand the gist). And if there's another post that answers this question, let me know
So many thanks!
Replace Field Contents can be used to update those records that were already there before you added this feature. You can perform a find to find all records where this field is empty and then use replace field contents to copy over the county name from the related record. (Use the calculation option for this.)