delivery

[Guest]

i have a delivery database. In it i have "projects" which our deliveries are
sent to. I want tobe able to send items to different shipping addresses under
the same project number. Currently in my projects have a ship company name,
address, phone, contact 9 and other related info. But my problem is that if i
am in the delivery form and i want to change the ship to company, address and
so on it changes it for all those projects. Is there something i can do so
that i can change it if i want to? I see it done in the northwind database
for there orders, but i am not sure how they do it.

Thanks

 

[Guest]

If you look at the CustomerId combobox's AfterUpdate in the Northwind form,
you'll see that the code is assigning a default Shipping address based on the
address fields in the customer record. This (overridable) shipping address is
stored in the orders table.

Barry