I am working on moving a 2.6 app to Sql 2005\Vb.Net. I have imported all of the tables and am in the process of adding additional needed fields, fixing some primary foreign key issues, changing field names etc.

I did not want to change a whole lot of the structure of the table's as the data will need to be converted so I wanted to minimize that amount of work. however there are multiple tables that use multiple address fields. For instance the customer table has address, billing address and shipping address.

So I am of course thinking that it would probably be better to create an address table to store all these pesky address's. Probably another table as well to store address types such as Main,shipTO, Billto etc.

Can anyone think of a reason I shouldn't use this approach? Or have any suggestions


Thanks Alot

Paul