Order form - same info in "Invoice to" & "ship to "

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Need a data entry form that will auotmatically show
customers to select in "Invoice to" box and also show in
the "Ship to" box, but allow to change the ship to when it
is different. I set my form up using Access Notrhfield
sample. But can't "enter" different ship to address
 
I don't know how the Northwind database is set up but this
would require you to have a separate table for multiple
ship to locations per customer. The first combo box would
list all of the customers and the second combo box would
filter to those customer locations equal to the customer
selected in the first combo box. You could use the
NotInList event on the second combo box to open a form to
add the new ship to address to the table.
 
I would store the shipto address in the individual invoice details, not in
the customer table, if it were overridden. Just a personal opinion.

Rick B

I don't know how the Northwind database is set up but this
would require you to have a separate table for multiple
ship to locations per customer. The first combo box would
list all of the customers and the second combo box would
filter to those customer locations equal to the customer
selected in the first combo box. You could use the
NotInList event on the second combo box to open a form to
add the new ship to address to the table.
 
Back
Top