K
Kevin Labore
I have a question to pass a list from either a table or query.
I have a list of departments for example and I want to pass these (sorted by
Category(Div#) and Dept#) so I dont have to enter them in the subform.
Presently I have the following tables:
DeptDate (the week end date(Sat) that the Sales Occured)
DeptSalesDetail (The Detail of DeptSales that occured on the DeptDateID)
Depts( The Dept#, Desc, Div(Cat))
Div (called division basically a category, Div# and DivName)
Goal to have the Subform automatically enter the Div# and Dept #(and Display
Deptname as well) so I dont have to manually enter 50+ lines for each
week(just enter the Sales$) -- Presently I have to type the department #'s.
I know how to do a selection list for each record.(ie. Red/Blue/Green) but
not how to do a set of records.
Thanks
Kevin
I have a list of departments for example and I want to pass these (sorted by
Category(Div#) and Dept#) so I dont have to enter them in the subform.
Presently I have the following tables:
DeptDate (the week end date(Sat) that the Sales Occured)
DeptSalesDetail (The Detail of DeptSales that occured on the DeptDateID)
Depts( The Dept#, Desc, Div(Cat))
Div (called division basically a category, Div# and DivName)
Goal to have the Subform automatically enter the Div# and Dept #(and Display
Deptname as well) so I dont have to manually enter 50+ lines for each
week(just enter the Sales$) -- Presently I have to type the department #'s.
I know how to do a selection list for each record.(ie. Red/Blue/Green) but
not how to do a set of records.
Thanks
Kevin