Automatic form field update based on previous form value selection
in [ASP]
|
Prev: Novice question on 'DetailsForm' and 'Grid'
Next: Automatic form field update based on previous form value selection
From: Brett_A on 18 Apr 2008 12:19 I have a form where the first field is a dynamic drop-down that pulls from a db (Access). The fields associated with the query are task_id, task_name and task_rate. The field has the value of "task_id" and the label of "task_name". In the second form field, I would like the default value to be determined by the selection made in the first field. Based on the selection of the first form field, I would like the default value of the this field (task_rate) to be populated with the associated task_rate value of the selection chosen above. Any suggestions? Thanks Brett
From: Evertjan. on 18 Apr 2008 12:59 Brett_A wrote on 18 apr 2008 in microsoft.public.inetserver.asp.general: > I have a form where the first field is a dynamic drop-down that pulls > from a db (Access). The fields associated with the query are task_id, > task_name and task_rate. The field has the value of "task_id" and the > label of "task_name". > > In the second form field, I would like the default value to be > determined by the selection made in the first field. Based on the > selection of the first form field, I would like the default value of > the this field (task_rate) to be populated with the associated > task_rate value of the selection chosen above. > > Any suggestions? If this is a serverside code problem, show your code, if it is clientside code or a html Q, ask elsewhere. -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress)
From: Brett_A on 18 Apr 2008 15:04 On Apr 18, 12:59 pm, "Evertjan." <exjxw.hannivo...(a)interxnl.net> wrote: > Brett_A wrote on 18 apr 2008 in microsoft.public.inetserver.asp.general: > > > I have a form where the first field is a dynamic drop-down that pulls > > from a db (Access). The fields associated with the query are task_id, > > task_name and task_rate. The field has the value of "task_id" and the > > label of "task_name". > > > In the second form field, I would like the default value to be > > determined by the selection made in the first field. Based on the > > selection of the first form field, I would like the default value of > > the this field (task_rate) to be populated with the associated > > task_rate value of the selection chosen above. > > > Any suggestions? > > If this is a serverside code problem, show your code, > if it is clientside code or a html Q, ask elsewhere. > > -- > Evertjan. > The Netherlands. > (Please change the x'es to dots in my emailaddress) Are for frik'n real Evertjan? This is an ASP forum, I'm asking an ASP question. I don't have the code because I need some direction on how to write the code. Did you read my question? Do you understand my question? Did I say I already have code that isn't working? I explain what I want and ask for suggestions. If my question isn't clear, than I need to fix it. Thanks Brett
From: Bob Barrows [MVP] on 18 Apr 2008 15:26 Brett_A wrote: > I have a form where the first field is a dynamic drop-down that pulls > from a db (Access). The fields associated with the query are task_id, > task_name and task_rate. The field has the value of "task_id" and the > label of "task_name". > > In the second form field, I would like the default value to be > determined by the selection made in the first field. Based on the > selection of the first form field, I would like the default value of > the this field (task_rate) to be populated with the associated > task_rate value of the selection chosen above. This is typically done in client-side code so it is more appropriately asked in a client-side scripting group such as microsoft.public.scripting.jscript However, you can look here to get a head start and narrow your question down to more specific issues: http://classicasp.aspfaq.com/forms/how-do-i-make-one-dropdown-depend-on-another.html While the client-side scripting is the major part of the solution, there may be server-side asp issues as well that we will be happy to address here. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
From: "Jon Paal [MSMD]" Jon nospam Paal on 18 Apr 2008 19:02
this may be of some help -- demo is for dependent dropdownlists... http://www.aspkey.net/aspkey/_articles/asp/showarticle.asp?id=100 "Brett_A" <brettatkin(a)gmail.com> wrote in message news:949f2283-ed72-4493-b2b1-0d800084cbd8(a)l28g2000prd.googlegroups.com... >I have a form where the first field is a dynamic drop-down that pulls > from a db (Access). The fields associated with the query are task_id, > task_name and task_rate. The field has the value of "task_id" and the > label of "task_name". > > In the second form field, I would like the default value to be > determined by the selection made in the first field. Based on the > selection of the first form field, I would like the default value of > the this field (task_rate) to be populated with the associated > task_rate value of the selection chosen above. > > Any suggestions? > > Thanks > > Brett |