K
karen scheu via AccessMonster.com
Can someone tell me if my design idea for having three field selections on
a form that generate display of order summary and order detail information
will work or if there is a better way to do this.
Here it goes:
User needs to select three fields in the following order:
Have a main selection form that contains three combo boxes as follows:
1. Division (list from table t_division in a combo box include all
2. Status (show all status from table order_status include all)
3. Order (List in combo box only orders that meet the above criteria)
On same form add the bound fields from the order summary query which is the
recordsource of the form
Create a subform and link the main form and subform on :
Main: Ordercombobox selection
Sub: Order Number
Show in subform the detail line items that make up the order.
a form that generate display of order summary and order detail information
will work or if there is a better way to do this.
Here it goes:
User needs to select three fields in the following order:
Have a main selection form that contains three combo boxes as follows:
1. Division (list from table t_division in a combo box include all
2. Status (show all status from table order_status include all)
3. Order (List in combo box only orders that meet the above criteria)
On same form add the bound fields from the order summary query which is the
recordsource of the form
Create a subform and link the main form and subform on :
Main: Ordercombobox selection
Sub: Order Number
Show in subform the detail line items that make up the order.