Making Dropdown Menu Dependent On Another Dropdown
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
View Replies
ADVERTISEMENT
i have three dependent dropdown list.when select city in first box then 2nd list will show all company for selected city. 3rd will show all jobs of co. any suggestion?
View Replies
View Related
I have a dropdown box getting data from a database, and I send the data to the database on form submition, But, I need to send another data to another column to the database according with the user dropdown box selecion. Example.
Dropdown option 1: DELL Corp.
Dropdown option 2: IBM Corp.
Dropdown option 3: Avante Systems
If the user select DELL Corp., it will send 'DELL Corp.' to the database but I need it to send dell.jpg to another column too. I have the code to send the data, but the relationship of the boxes is 'the thing'.
A solution almost like bellow is what I am looking for, but instead of, the selection in the first combo should point to another selecion in the second combo (so the second combo will have the dell.jpg value): http://forums.aspfree.com/code-bank...own-137839.html
View Replies
View Related
I want to have dependent dynamic dropdown lists where the person can select the state, then county, then zip code, and all 3 of these menus will be populated by a database. I have a page that Ive been working on but I just cant get it. The page I am working on also refreshes when you select the state, then when you select the county it refreshes again but instead of populating the zipcode list it just takes the state name and inserts it into the city menu. Code:
View Replies
View Related
i'm trying to create a dependent dropdown menu based on two objects, packages and steps (the steps dropdown will be dynamically updated/populated when a package is selected). the site uses ASP and since ASP is server-side, i am using JavaScript to handle the client-side "dynamic" change.
i've found several snippets of code that create the dependent dropdown; however, the two examples i have use arrays which are statically defined. the data that will populate the dropdowns is coming from a SQL database, and that data will be updated/changed fairly often. my question is this: is there any way to generate the arrays using ASP (outside javascript tags) and use them in the javascript?
or is there a way to use javascript to generate the correct arrays and fill them with data from my SQL tables? can i use a recordset ojbect in javascript? i have heard that you may use PHP inside javascript tags, but i'm unsure if that is what i want to do.. especially since i am using ASP as the main language for this site. Code:
View Replies
View Related
I'm using this code to populate a drop down menu and i'm using a query to populate the menu with certain info. from the table column. How could I add other drop down menus to this form and have them filled with different info than in the first drop down menu but still be in the same form? Code:
View Replies
View Related
I have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
View Replies
View Related
I have 2 drop down menus with data populated dynamically from a database.
Category
Subcategory
If i select an appropriate category the subcategory should change instantly to show the subcategories relating to the selected category. But i can't use a form submit, because before the forms are other textboxes with other values that i don't want to wipe on a page refresh.
I need to somehow preload the categories and their related subcategories. I've been trawling through examples, most are harcoded combobox values which won't work for me.
View Replies
View Related
I have a dynamic drop down menu created from an Access 97 database. The munu contains numbered indexes. Is there a way to have Index 10 displayed after Index 9 instead of after Index 1.
View Replies
View Related
I have an access db called boards and a table in it called notes. I have 3 fields in the table ID, subject, and notes. I have code to search the db and display the results in the notes field.. This code works very well. I wanted to modify this code so that I can use a dropdown menu instead of type in the search field but i cannot get the dropdown menu code to display the search results. Code:
View Replies
View Related
I am trying set up a page where the user can view records chosen by the year.
I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
View Replies
View Related
Does anyone have any code to display a dynamic dropdown menu (similar to Windows Start menu)? There seems to be a browser compatability problem with most that I've seen.
View Replies
View Related
I am trying to get the value of a dropdown box which is populated from a access database.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("mydb.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT DISTINCT Company FROM Customers ORDER BY Company"
rs.Open sql,conn
company=request.form("company")
%>
I need to send dthe value of this dropdown to the next page which will response.write the company name. Any ideas on how to do this?
View Replies
View Related
i had done coding for two dependent dynamic drop down boxes.taking code from http://forums.aspfree.com/t53159/s.html......it is working nice
but now select 2nd box and populate 3rd one.i m very confused how make a changes in code for 3rd one.if any of u
have time i can send my code for urs technicalful advise
View Replies
View Related
I have code to present on this forum, but not with me at the moment. This is what is happening now. On my page there is a drop down box that calls on an onChange javascript function. The drop down box dynamically displays locations depending on the location of the cars.
Therefore...if Toyota Camrys are in Philadelphia and New York, the drop-down box will display: ALL, Philadelphia, and New York. Selecting one will filter out only those in that location.
What i want to do is...change it so...it displays dynamically the locations horizontally...here is an example: PREFERED LOCATION? ALL PHILADELPHIA NEW YORK (all are links to filter out those that do not match the location).
i need to do it to save space and make it more user-friendly.
View Replies
View Related
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page. Code:
View Replies
View Related
I've got an XML file that I use to populate a treeview control and a dropdown box. That works fine, although I now want to be able to sort the list of people in the dropdown list. Someone suggested using an XML template, but I'm a bit of an XML newbie and not sure how to do this. Code:
View Replies
View Related
Lets say you have a dropdown box with few options in it. Several products have such a dropdown box. is there a way to do this following stuff.
I want one of that options in the dropdown box to be 'unique'. When selected, it would dissapear, or it can't be clicked on, on another product's dropdown. 'yes or no' answer would do just fine for now.
View Replies
View Related
Now that I can store variables from a form listbox into a session variable... say there are 4 options from the dropdown like
model
type
area
performance
and the user selects performance.. I store the string "performance". now how do I place it back into the listbox after the user hits 'submit'? that way the selected values are shown.
View Replies
View Related
i have a web page which allows user to update Subject information. There may be several subjects in the dropdown box. However, each person will have a subject allocated to him when he is inserted into the database.
As such, now when i want to update his particulars, in the Subject dropdown box, i would like to set his Subject to the one in the database followed by the rest which he can choose.
Eg.
Originally, Subject = Literature
Update:
in Subject dropdown box, i will see Literature at default but when i click the dropdown box, i will see the other options such as History, Gepgraphy etc. How should i go about doing this?
View Replies
View Related
I have seen some techniques like this on the web. Currently, I'm using Combo
box which values came from database table. One disadvantage is when the
combo box have lots of values, users are complaining since you cannot use
keyboard to search the value that is needed.
View Replies
View Related
I'm trying to put a drop-down box on an asp, which will containing a list of
names.When a user starts typing a name that is in the list I want the text to
autocomplete
e.g. when the user types 'st' I'd like the text to autocomplete to steve or
stephen, depending on which is first in the list.
View Replies
View Related
How to display sql database data to dropdown list in asp?
View Replies
View Related
It gives me a blank dropdown when there are values in the Currency Table and
it also does not display any form element that I place after this code.
<select size="1" name="Currency" >
<%
SQL = "Select CurrSymbol FROM Currency "
SET RS = CONN_STRING.Execute(SQL)
While NOT RS.EOF%>
<option value="<%=RS("CurrSymbol")%>"><%=RS("CurrSymbol")%></option>
<%
RS.MoveNext
WEND
Set RS = NOTHING
%>
</select>
View Replies
View Related
i now have my dropdown connected to my database. everytime the user adds a new record, he simply has to choose a Department from the dropdown menu. However, when he tries to edit that record, the value that he has chosen from the dropdown and has been saved to the database cannot be retrieved in the dropdown menu.
so i want to retrieve the data from the database INTO THE DROPDOWN so it would be the default value of that dropdown menu when the user edits his specific record.
View Replies
View Related
I would like to display 15 items (lines) in the dropdown list, but by
default the list displays only 11 lines. How can I have all the 15 items
displayed in my dropdown list
View Replies
View Related
How would I format this dropdown box to uppercase and where would I place the UCase syntax?
<SELECT name="txtSearchCity" class="form">
<%
Do while not Rs.EOF
%>
<option value="<%=Rs("Addr City")%>"><%=Rs("Addr City")%> </option><%=Rs("Addr City")%>
<%
Rs.MoveNext
loop
%>
</SELECT>
View Replies
View Related
i have two dropdowns(dd1 & dd2) in the same page. dd2 items depends on the item index from dd1.when dd1 is onchange, the form will get the dd1 index value and then do a search in DB for the results to be input into dd2.How can i achieved that?
View Replies
View Related
Here is my page:
<form name=myForm>
<select onChange="myForm.forename.value = this.options[this.selectedIndex].value;">
<option value="Arnold">Pam
<option value="Mokoena">Joe
<option value="Seth">Pat
</select>
<input type=text name=forename disabled>
</form>
when inserting on the database,the value of the dropdown option is the same as the value of the textbox which is wrong.they must not have the same values example
when Pan is selected,then the value inserted to the database must be "pam" not Arnold.
View Replies
View Related
what If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?
View Replies
View Related
I have a table called tblParts. The are 3 fields: PartID, PartNumber and Price. I have a dropdown box on my ASP page that is dynamically populated with PartNumbers from the database.
I have a text field for the price. I want it when the user selects a part number from the dropdown to display the correct price in the textbox for that part. I "DO NOT" want the page to reload.
View Replies
View Related
Ok what I did is worked on a model code and put three checkboxes which I would like to enable the dropdow by checking one (or all 3) and disable when none is checked.
Just to let you know, I will insert this in a multicheckbox page. I hope there is no confusion with other checkboxes. Code:
View Replies
View Related
I want to make a dropdown using a column from my table in the list of the dropdown.
What's wrong with this?
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
View Replies
View Related