Combobox Not In List

D

David M C

Tables:

Orders:
OrderID pk autonumber
SupplierID fk
OrderDate
etc

OrderDetails:

OrderDetailsID pk autonumber
OrderID fk
Description
Quantity
etc

Suppliers:

SupplierID pk autonumber
CompanyName
Address1
Address2
City
etc

On a form, I have the usual Order, Order Details setup. In the main form I
have a Supplier combobox, bound to SupplierID in the orders table, but
showing CompanyName. The address information is displayed in text boxes
depending on the supplier selected.

Quite often, an order will be placed with a new supplier. The users often
try to enter the new company name in the combobox and the address information
in the text boxes below. How can I have this information added to the
Suppliers table? The combobox is currently set with Limit To List = Yes. At
the moment, I make them use a seperate form to add the new supplier but it is
quite longwinded and more importantly, not what they expect to happen.

Thanks

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top