I need some expertise on a project I’m working on. In the stripped down version of the attached database there is an order form, customer table, order table and an order query
The only fields on the form are the top combo box (company) below that is another combo box (customer/contact) below the 2 combo boxes are 4 textboxes: street, city, state, zip, respectively.
The upper combo box’s control source is an SQL table/query -(companyname).
The lower combo box’s control source is from the same table/query - (customer).
The following 4 text boxes are populated with values from the same table/query determined by the value in the lower combo box (customer/contact).
This allows a user to select a company (if exists) from the company combo box list and then the lower combo box and text boxes are automatically populated.
IF there is no company associated with the sale the user can pick just a customer/contact and,then again, the lower text boxes are automatically populated.
There will always be a customer BUT not always a company associated with the sale.
I have a separate form used for entering new customers into the customer’s table. Is it possible to have the same 2 combo and the 4 text boxes mentioned above to be utilized for new customer entry too? I looked around and but haven’t found anything actually directed at this – then again I’m not sure what function it would be under, i.e. would I use “not in list”, “after update”? Can someone push me in the right direction?
Also, since NOT all customer records will have a company listed but all will have a customer listed - the customer is the relationship between the “orders” tables and the “customers” table. In this scenario when clicking on the company comb box the list displayed has gaps or spaces where no company is listed (blank cell) is there a way to shield or eliminate the gaps?
Any and all help will be much appreciated!
Thank you’
Vince
P.S. I won't be able to respond until tomorrow - I'm have to leave in thirty minutes........Thanks again
The only fields on the form are the top combo box (company) below that is another combo box (customer/contact) below the 2 combo boxes are 4 textboxes: street, city, state, zip, respectively.
The upper combo box’s control source is an SQL table/query -(companyname).
The lower combo box’s control source is from the same table/query - (customer).
The following 4 text boxes are populated with values from the same table/query determined by the value in the lower combo box (customer/contact).
This allows a user to select a company (if exists) from the company combo box list and then the lower combo box and text boxes are automatically populated.
IF there is no company associated with the sale the user can pick just a customer/contact and,then again, the lower text boxes are automatically populated.
There will always be a customer BUT not always a company associated with the sale.
I have a separate form used for entering new customers into the customer’s table. Is it possible to have the same 2 combo and the 4 text boxes mentioned above to be utilized for new customer entry too? I looked around and but haven’t found anything actually directed at this – then again I’m not sure what function it would be under, i.e. would I use “not in list”, “after update”? Can someone push me in the right direction?
Also, since NOT all customer records will have a company listed but all will have a customer listed - the customer is the relationship between the “orders” tables and the “customers” table. In this scenario when clicking on the company comb box the list displayed has gaps or spaces where no company is listed (blank cell) is there a way to shield or eliminate the gaps?
Any and all help will be much appreciated!
Thank you’
Vince
P.S. I won't be able to respond until tomorrow - I'm have to leave in thirty minutes........Thanks again
