Wednesday, March 21, 2012

Many Addresses in a database

I need to allow for many addresses in my database for each client that is entered. I'm looking for suggestions on how I should handle this. I will need to do mailings to the clients and will need a way to select the address record that the client indicates as the mailing place.

Thanks for any thoughts.have a table that holds has clientid and address columns...a query by clientid will give you all the addresses on file and the user can chose which one to be used...

hth|||Go to amazon and ge the "Data Model Ressource Book". Has nice examples on how to manage addresses. Very interesting reading.

No comments:

Post a Comment