Tempory Address's

[johnbowser11]

Hi Ive got a form that has customer details at the top i.e name, address etc. and then a products subform. Once I have chosen a customer it then automatically fills in the address fields and i can then add products to the order. I then press a button which produces a form showing the customer name and address and the products they ordered. I want to be able to have it so I can add a tempory address if the customer wants the goods to be shipped somewhere different to there normal address. How do I do this without adding another address into the database?

 

[johnbowser11]

Anyone?

 

[Mile-O]

A bit impatient this morning, aren't we?

So, why not store multiple addresses for a customer?

 

[ColinEssex]

I have an orders database and use separate fields in the customer table for an invoice address if different from the delivery address. Works fine.

Col

 

[johnbowser11]

Because it may be for a customers customer if you see what i mean. All I need is to have some sort of alternate delivery address option, but cant for the life of me work out how to do it.

 

[ColinEssex]

Why not store multiple address as SJ said?

If the customer is Fred Bloggs of Swindon and the delivery is to Joe Brown in Hastings. . . . . . . .whats the problem? As long as the invoice goes to the customer and the goods to the delivery address. . . . .

Col

 

[johnbowser11]

ahhhh ok, the invoice address entry int eh customer database sounds like the way to go! MAny thanks for your helpo everyone