How to match adress with zip code?

[FaxModem]

Hi there,

As you will know by my question, I am a very fresh Filemaker user..

I come from Norway and our adresses and zip codes are like this example:

• 3200 Sandefjord

I have imported all the combinations to a table with two fields called "Zip" and "CityName". There are 4711 records.

After entering a Zip code in one field and entering the "CityName" field, I would like it to find it automatically by matching it to the table with every combination avaiable in our country.

All help are appreciated

[FaxModem]

Since there may be more like me out there, I will answer the question myself..

The key to this simple problem really is LOOKUP VALUE

Example:
- 'Customer' table with fields for Name, Zip and City
- Another table 'ZipCity' with two fields for Zipcode and Cityname
(This list you import from 'Bring' if you need the Norwegian on)

1) Go File/Manage/Database and relate the two tables matching from Customer::Zip to ZipCity::Zip
2) Then go to Field Tab and dobbel click on the Customer::Cityname field
3) Then press 'Specify' to the right of the text 'Looked-up value'
4) Choose then:

• 'Starting with table:' Customer
• 'Lookup from related table:' ZipCity
• 'Copy value from field:' Cityname
• 'If no exact match, then:' do not copy

Just close up all the windows and try to make a new record.

That should do the trick! I've used several hours on this issue today before I suddenly find it, and so darn easy hehe.

[FaxModem]

...