Hey everyone,

I have been killing myself trying to figure out how to do this if it is possible. I am creating an VB/ASP page that will allow a user to enter Purchase Order information into an SQL database. The problem is when I set up a dynamic list/menu from the products table, it will populate a recordset based on product ID which in return will display that products description and cost columns into seperate text fields. What I can't figure out is when there are multiple dynamic list/menus on multiple forms, the user will select which product they want and it will place that products id cost and description info into a field without the user having to click submit on each form. So to sum it up, I need to know how to have multiple forms with multiple list/menus on a page that will allow the user to select the dynamic data and based on their selection it will immediately poplulate another field with the correct database column info (cost and description) for each list/menu box selected. Much appreciation for any help!!!! THANKS!!!

What server technology are you using? You have two options.

One is to have your users make the selections then click submit which will send the form to another similar page loading the values from the dynamic menu they selected.

The next would be to use the Runat="server" which requires extensive knowledge of VB and .net.

You could use DHTML to set the text field values when the user releases the pull down menu however I am not certain how that would work as you would have to change the cursor depending on the record selected.

I'm sure there are other ways... Good Luck