L
Lesley
I have a concern that may or may not be an issue regarding the design of this
database...
First, I created a select query called Delivery Summary ALL, which is based
on an Invoice table and a Delivery Time table. Next, I created another
select query called Delivery Group based on the Group Name table and the
Delivery Summary ALL select query. From there, I created the Delivery By
Group Form (autoform format), which is based on the Delivery Group query
where the Group Name is to be filtered by the combo box dropdown list. It's
Rowsource (in the combo box) points to the Group Name table (for the account
# and group name).
Question - can the combo box filter on group name on the form if both fields
are pointing to the Group Name table??? Please advise...
Thanks Lesley
database...
First, I created a select query called Delivery Summary ALL, which is based
on an Invoice table and a Delivery Time table. Next, I created another
select query called Delivery Group based on the Group Name table and the
Delivery Summary ALL select query. From there, I created the Delivery By
Group Form (autoform format), which is based on the Delivery Group query
where the Group Name is to be filtered by the combo box dropdown list. It's
Rowsource (in the combo box) points to the Group Name table (for the account
# and group name).
Question - can the combo box filter on group name on the form if both fields
are pointing to the Group Name table??? Please advise...
Thanks Lesley