Multiple adresses for a customer

[tostgulen]

Hi

I have a database where the customers can have multiple addresses. Billing address, visiting address, post address, etc. I have a customer table and a table containing Norways ZIP codes and corresponding city. I realize that what I need is a many-to-many relationship so I created a new CustomerZIP table. My problem is: how do I connect the right zipcode to the right address type?

This is probably a really simple problem, but I cant quite get it to work. I would like the end "product" to automatically look up city to the correct address.

[pbaldy]

I may be missing something, but I don't see the purpose of the middle table; I'd have the zip in the customer table. In that design, you would add the zip table to a query 3 times, and join each zip in the customer table to a different instance of it.

[Bob Fitz]

I would use a different table arrangement. See attached db.

[tostgulen]

I would use a different table arrangement. See attached db.

Excellent Thank you so much! That will work.