Need Help with this Problem!! 1

[natemclain]

Hey guys & gals,

I need some suggestions on how to get this to work as easily as possible. I have thought about it and haven't come up with anything that will work yet. Here is the problem.
I have a order form. And I have the companyname, billing address, state, city... etc. Then I have on the same form a ShipTo Address. But some customers want there product sent to different locations from time to time. The max is 3 different ShipTo locations so far. I would like to make it so that whoever makes out the order can just select which place they would like to have it ShipTo. Can anyone describe how this can be done? Or post a good DB that I can download to look at to see how this can be done.


TIA

natemclain

 

[JoeMiller]

You need a table tied to your customer table to store shipto data. Often you'll have a customer id and a ship to id, the user then can select which ship to. It sounds like you put the ability to record three records in the customer table for recording ship tos? By moving it to a new table you'll get an unlimited number of ship Tos and the ability to relate them and select them on your orders.

HTH Joe Miller
joe.miller@flotech.net