Novice needs code help

[dab1477]

Thanks for your patience and assistance.

I have a database that collects downtime and scrap for a
series of work centers. I would like to do the following:

When I choose a specific workcenter from a dropdown menu
in a form, I would like to populate another dropdown menu,
within the form,with a listing of downtimes and scrap
reasons specifically for that workcenter.

Ex. If I choose "LINE 2" as a work center, when I get to
the "Downtime" input box, I would like to choose from a
list of downtimes specifically related to Line 2. I would
want to do the same for "Line 3", etc.

I have a table with all the work centers. I have this
linked to the Work Center input on my form. I also have a
table for EACH line's downtime and scrap reasons. I don't
know how to code to have "Line 3 Downtime" populate the
Downtime drop down menu after I update Work Center
to "Line 3".

I have a total of 15 work centers, each with differing
downtime reasons.

Thaks so much for the assist to a newbie....

 

[Larry Linson]

Life would be so much easier if you had one table for downtime and scrap,
each record identified by workcenter. (You see, your tablename is data, now,
and that's a violation of relational design principles.) If you had the
one-big-table design, you could put a subform on your form and use the
workcenterid's as the LinkMasterFields and LinkChildFields to synchronize
them.

Larry Linson
Microsoft Access MVP