P
Phil
Hi Everyone,
I'm new to google groups, deciding to join after seeing the wealth of
information and advice that you folks possess. Here's my problem:
I am designing a work flow application that will allow a shop to track
it's work flow using a work order form in Access. This form is based
off of the WORK_ORDER table, pulls in related data from CUSTOMER table
via Dlookup(), and has 3 subforms.
Work order line subform is based off of table WORK_ORDER_LINE and is in
continuous form format, as is it's companion subform based off of
WORK_ORDER_LINE_STATUS. All subforms are using Work order # for their
relationship, and while WORK_ORDER_LINE and WORK_ORDER_LINE_STATUS are
related in a one to one relationship behind the scenes, I have simply
placed them side by side on the form as continuous subforms.
The third subform is the important one and is based off of the table
WORK_ORDER_STATUS. As it's name implies, this table is for each
department to indicate when they are finished with a particular work
order and the work order is ready to move on to the next department.
Each department must be able to see only those work orders that relate
to them, so searching the WORK_ORDER_STATUS for appropriate orders is a
necessity. I can use access built in filter to filter my form based on
main form fields, but I am struggling to filter these work orders based
on the WORK_ORDER_STATUS table/subform. As the users will be largely
computer illiterate, it makes sense to display all results using the
work order form.
Initially I wanted to base this main form off of a query, but found
that the continous subforms would limit themselves to one line per main
form due to the duplicate work order numbers that such a query creates.
In researching this problem, I find numerous solutions suggesting I
base the form off of a query, but in this case I can't get it to work
and still have my work order lines flow over to my form. (there are
anywhere between 0-50 work order lines per work order)
Any suggestions on how to filter my table based work order form by the
work order status subform?
I am also open to the possibility that there may be a better way to
create a form that would allow me the filter flexibility I need...
Thanks,
Phil
I'm new to google groups, deciding to join after seeing the wealth of
information and advice that you folks possess. Here's my problem:
I am designing a work flow application that will allow a shop to track
it's work flow using a work order form in Access. This form is based
off of the WORK_ORDER table, pulls in related data from CUSTOMER table
via Dlookup(), and has 3 subforms.
Work order line subform is based off of table WORK_ORDER_LINE and is in
continuous form format, as is it's companion subform based off of
WORK_ORDER_LINE_STATUS. All subforms are using Work order # for their
relationship, and while WORK_ORDER_LINE and WORK_ORDER_LINE_STATUS are
related in a one to one relationship behind the scenes, I have simply
placed them side by side on the form as continuous subforms.
The third subform is the important one and is based off of the table
WORK_ORDER_STATUS. As it's name implies, this table is for each
department to indicate when they are finished with a particular work
order and the work order is ready to move on to the next department.
Each department must be able to see only those work orders that relate
to them, so searching the WORK_ORDER_STATUS for appropriate orders is a
necessity. I can use access built in filter to filter my form based on
main form fields, but I am struggling to filter these work orders based
on the WORK_ORDER_STATUS table/subform. As the users will be largely
computer illiterate, it makes sense to display all results using the
work order form.
Initially I wanted to base this main form off of a query, but found
that the continous subforms would limit themselves to one line per main
form due to the duplicate work order numbers that such a query creates.
In researching this problem, I find numerous solutions suggesting I
base the form off of a query, but in this case I can't get it to work
and still have my work order lines flow over to my form. (there are
anywhere between 0-50 work order lines per work order)
Any suggestions on how to filter my table based work order form by the
work order status subform?
I am also open to the possibility that there may be a better way to
create a form that would allow me the filter flexibility I need...
Thanks,
Phil