Help with Displaying different values in a Drop Down Menu

[Deano252]

Hi:

I've been figuring a good way to do the following problem for a couple of days now..

I have two database tables 1 is called Mfg. and it has a manufacturer name and an ID Number of the manufacturer

the other table a collection of all PartNumbers and they have a Mfg_id that relates to the Mfg table.

anyways.. what I need to do is build a form and have 2 dropdown menus the first one is where the user selects the manufacturer and the second one populates itself with all the Part Numbers that match the selected manufacturer..

I've seen a few tutorials on the web but they wern't very good at explaining what to do..

if anyone can help me out I would appreciate it
Dean Forant

 

[mwolf00]

faq333-1498

faq333-3656



Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)