B
babs
I would like to create a drop down list for ovens, I have a table of all of
the available ovens for the day. Primary key is oven#. I have a table that
assigns oven# to given orders. (call it order details) on this table there
is a checkbox field says OVEN no longer available for use. I would like the
order details form to have a oven drop-down list(presently-pulling it from
the ovens table- shows all ovens wether-not really available) that would
include ALL available(meaning checkbox not checkoff) ovens. And at the end
of the day - I would like ALL of the ovens to be RELEASED and now all ovens
available for drop down at start of new day. This sound odd but it is how or
business works. Feel kind of looping - not sure how to do. Please help if
you can.
Thanks,
Barb
the available ovens for the day. Primary key is oven#. I have a table that
assigns oven# to given orders. (call it order details) on this table there
is a checkbox field says OVEN no longer available for use. I would like the
order details form to have a oven drop-down list(presently-pulling it from
the ovens table- shows all ovens wether-not really available) that would
include ALL available(meaning checkbox not checkoff) ovens. And at the end
of the day - I would like ALL of the ovens to be RELEASED and now all ovens
available for drop down at start of new day. This sound odd but it is how or
business works. Feel kind of looping - not sure how to do. Please help if
you can.
Thanks,
Barb