M
Marissa via AccessMonster.com
OK, here's the issue...
I have a data entry form that lets you enter your cust info and includes two sub forms. Subform 1 lets you enter products *only* for sale to that specific cust. Subform 2 lets you enter the sales people who will get the commission off the sale. (Everything is connected correctly w/ master & child fields) For every sale, all sales people for that cust get the commission (usually 2 or 3).
My prob is this: I am now creating my order form. I have a combo box that lets you select the cust and brings in all the info. My subform (where I enter the sale) has a combo box that lets you select what product the cust is buying. I need a way to do the following:
1) Make the products listed in the combo box change depending on which cust has been selected
2) Have the correct salespeople's info come in so they get the correct commission
Any help would be EXTREMELY appreciated!
THANK YOU!!!
I have a data entry form that lets you enter your cust info and includes two sub forms. Subform 1 lets you enter products *only* for sale to that specific cust. Subform 2 lets you enter the sales people who will get the commission off the sale. (Everything is connected correctly w/ master & child fields) For every sale, all sales people for that cust get the commission (usually 2 or 3).
My prob is this: I am now creating my order form. I have a combo box that lets you select the cust and brings in all the info. My subform (where I enter the sale) has a combo box that lets you select what product the cust is buying. I need a way to do the following:
1) Make the products listed in the combo box change depending on which cust has been selected
2) Have the correct salespeople's info come in so they get the correct commission
Any help would be EXTREMELY appreciated!
THANK YOU!!!