Default Value from entry in another table

[marystewart78]

Hi Everyone,

I am creating a customer order database and have a table for customers with a billing address and one for orders with a delivery address. Most orders go to the billing address, however, the odd order may go else where so I would like to set the default delivery address for each order in the orders table to be the billing address from the customers table for quickness but be able to change this when required to another delivery address - How can I do this?

Is it also possible to have any new delivery addresses added to a list so the user can pick from the list in future?

Many Thanks

Mary

 

[Pat Hartman]

An easy way is to copy the address fields from the customer table to the ordertable as soon as the order is created. An alternative is to use a button to copy them on demand.