Customers with multiple shipping addresses
Hello to all,
How can create a client profile with multiple addresses, so that wen I'm creating an invoice I can choose which address to send it to? Here is an example of what I want to do. From the client form I can click a button for add new address and the new address window pop up.
Worse case scenario is two addresses or more?
Shipping is to one of two or more addresses, or shipping to mulitple addresses.
A table for addresses would be the most obvious choice - addressID, unique, auto enter as the relationship field to ClientID
The same concept as having a Table for Email, many people have more than two or three email addresses, or phone numbers.