M
MooliiBeth
I'm working on making a form in which the values available in a "code" drop
down box are related to a value entered in the "work center" field and the
"category" field above.
I would really like the values entered in the "work center" and "category"
fields to be stored in the database and then also be used to create a drop
down box with only those codes associated with the work center as options.
Between 10 and 20 codes relate to a specific combination of work center and
category. However, a complication is that work centers: WL1, WL2, WL3, WL4,
and WL5 all have unique codes related to a category, but workcenters entitled
WS1 through WS12 all should share the same code options. I have a table that
has the "workcenter" "category" "code" and "description" fields, so I am
thinking I can use a query of some kind to look up the data on that table to
connect to the drop down box. This table does not distinguish between
WS1-WS12 (I just used a generic WS as the category). The table does
distinguish the codes for WL1, WL2, WL3, WL4, and WL5 and the category part
is labeled accordingly. I'm not sure if it matters, but the info will be
stored on a table with these fields plus a few more data entry categories,
including things like the quantity and date.
Please help!
Thanks!!
down box are related to a value entered in the "work center" field and the
"category" field above.
I would really like the values entered in the "work center" and "category"
fields to be stored in the database and then also be used to create a drop
down box with only those codes associated with the work center as options.
Between 10 and 20 codes relate to a specific combination of work center and
category. However, a complication is that work centers: WL1, WL2, WL3, WL4,
and WL5 all have unique codes related to a category, but workcenters entitled
WS1 through WS12 all should share the same code options. I have a table that
has the "workcenter" "category" "code" and "description" fields, so I am
thinking I can use a query of some kind to look up the data on that table to
connect to the drop down box. This table does not distinguish between
WS1-WS12 (I just used a generic WS as the category). The table does
distinguish the codes for WL1, WL2, WL3, WL4, and WL5 and the category part
is labeled accordingly. I'm not sure if it matters, but the info will be
stored on a table with these fields plus a few more data entry categories,
including things like the quantity and date.
Please help!
Thanks!!