Alternative Delivery Address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone please help. I have a typical database with customer, orders, and
orderdetail tables and queries.
Most of the time orders are shipped to the order originators address details
of which are held in the Cust table.
Occassionaly I wish to raise an Invoice using a different address etc.
What is the best way to approach this situation.
 
You might want to think it through as to how often it happens and maybe build
tables to support multiple addresses for the customer.

Have customer information in a table with financial stuff but set a relation
to address table. You can use a make table query to pull all the current
address data into the new table.
 
Thanks Karl for your quick reply. I will try this, its something I have not
done before so may need some more help, any way Ill see how it goes
 
karl
Sorry I thought I understood what you meant by a relation to address table
until I came to do it !! Could you expand please
 
Back
Top