Hi,
Seems like you have to use the onchange event for the manufacturing
drop down box and call the same form, passing the id of the
manufacturing to the next state in the same form and pass it to the
sql statement to query those part numbers related to that
manufacturing id. Execute that sql statement and populate that second
drop down box.
TS
--- In [EMAIL PROTECTED], [EMAIL PROTECTED]
wrote:
> Hi People:
>
> I have a little problem I'm trying to solve. I'm writing an asp
> script that allows the user to select a certain part number based
on
> the manufacturer that they select..
>
>
> I have 2 database tables the first one is manufacturer witch is
just
> the mfg. name and the mfg_Id
>
> the other table the partnumbercrossreferance table which contains
all
> the partnumbers and I can match those records to the Mfg_id field
in
> the manufacturer table..
>
> what I want to do is when the user selects the manufacturer from
the
> first pull down menu of the form I need the second Pulldown menu of
> the form to populate with all the part numbers of the selected
> manufacturer..
>
> any suggestions on how to go about an easy way to get this done..
>
> Thanks
> Dean Forant
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
