I have several curstomers records and it would be so good if it was possible find adresses customers by the zip code. How can I do it?
Enter find mode.
Type the zip code
perform the find
can find all records with a given zip code.
But other methods are also possible and any method can fail if your design doesn't work withe that method and you have told us nothing about your design.
Maybe I didn't know to express my idea. I would like to insert the zip code and the others fields about de adress would fill automatically, like what happens with web sites in general.
This is typically done by having a separate table that cross-indexes zip codes against cities and states. Here's the "official" site for the data:
in what country ??
This is the link for a "Códigos postales de México"
and this is an picture, how i made it ¡¡
I hope you like
Excuse my english
Oh, no problem! I understood everything! I'll try to test your method. But I'm using the FileMaker Pro 11. Is it so different of your version?
Thank you so much!
You need obtain the zipcode from Brazil
You may obtain from here
Complete List of Brazil Postal Codes | AggData
You only need adjust your DB
Please mark a solved your original cuestion
I need to create a new table with this zipcode data inside of the database, right? And after that, I make the relation?
As a general observation to your need, in some countries a zip code does not exactly identify a "place".
Example: in Switzerland the zip code 9249 belongs to 3 places:
Algetshausen (600 residents)
Niederstetten (140 residents)
Oberstetten (110 residents)
so in cases like that you don't want an automatic fill of the "City" via lookup or other, you want a popover allowing you to choose the specific place.
Once you've got your hands on the specific zip code table you need, do a simple search with "!" in the zip code, to check if you need to cover the scenario I've illustrated.
I make a Table outside the database and in the TO call a external reference.
Retrieving data ...