Dynamic Drop Down Menus
I've 4 fields in my access database.
Field1
Field2
Field3
Field4
All of them are need to be displayed on the ASP page. But in the drop down boxes. Field1 should be displayed in first dropdown menu. When an item from the drop down menu is selected then the second dropdown menu should be filled up by Field2 acc. to the data in the first drop down and so on for the third drop down menu and Field3. After that there should be a submit button. On clicking the button, the Field4 should be displayed in the page under all of the dropdown menus.
I need the working code for 4 fields immediately. All of the fields are of text type and size is 25 characters per field. Create the database yourself with these 4 fields.
Please send the codes at chadhaajay@hotmail.com as soon as possible. I'll increase the points for a quick and working answer.
Good Luck..
Ajay Chadha ... :-)
Field1
Field2
Field3
Field4
All of them are need to be displayed on the ASP page. But in the drop down boxes. Field1 should be displayed in first dropdown menu. When an item from the drop down menu is selected then the second dropdown menu should be filled up by Field2 acc. to the data in the first drop down and so on for the third drop down menu and Field3. After that there should be a submit button. On clicking the button, the Field4 should be displayed in the page under all of the dropdown menus.
I need the working code for 4 fields immediately. All of the fields are of text type and size is 25 characters per field. Create the database yourself with these 4 fields.
Please send the codes at chadhaajay@hotmail.com as soon as possible. I'll increase the points for a quick and working answer.
Good Luck..
Ajay Chadha ... :-)
Mark Franz
PAQ, about a hundred times... do a search on dynamic select lists
ASKER
Hello mgfranz,
Could you please send the exact code to me
Could you please send the exact code to me
"exact" ?
ASKER
Yes Exact...!!!!!!1
Ajay chadha .. :-)
Ajay chadha .. :-)
ASKER
Hello, IS there anybody..???
Ajay Chadha .. :-)
Ajay Chadha .. :-)
> I've 4 fields in my access database.
in the same table? in different tables?
give me the exact tablenames and fieldnames...
and add some more points, if you want the whole code ;-)
in the same table? in different tables?
give me the exact tablenames and fieldnames...
and add some more points, if you want the whole code ;-)
ASKER
In the same table. All are of type text.
I'll definitely increase the point to double if got a working code in ASP.
Ajay Chadha .. :-)
I'll definitely increase the point to double if got a working code in ASP.
Ajay Chadha .. :-)
ok... but first i need some more info to understand your problem right....
how can they be in the same table?
lets say i have just two dropdownboxes where the first holds groups and the second holds the member of the selected group, then you would need TWO tables like this:
groups:
id (PK)
name
members:
id (PK)
name
group (FK on groups)
members.group holds a reference to the group a member is in..., so i know which members to show in the second dropdownbox if a certain group is selected...
how do i know this from your table?
how can they be in the same table?
lets say i have just two dropdownboxes where the first holds groups and the second holds the member of the selected group, then you would need TWO tables like this:
groups:
id (PK)
name
members:
id (PK)
name
group (FK on groups)
members.group holds a reference to the group a member is in..., so i know which members to show in the second dropdownbox if a certain group is selected...
how do i know this from your table?
ASKER
Ok, Give me the code for that...
Ajay Chadha ... :-)
Ajay Chadha ... :-)
ASKER
Hello ASPGuru ,
Please send it as early as possible.
Ajay Chadha ... :-)
Please send it as early as possible.
Ajay Chadha ... :-)
ASKER
Hurry UP Man..
ok, will give you code for this... need some time...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"Hurry up man..." LOL!
Guru, you crack me up...
chadhaajay, the chances of anyone here sending you the exact code you need is slim ot none... a couple hundred $$'s should help though...
Guru, you crack me up...
chadhaajay, the chances of anyone here sending you the exact code you need is slim ot none... a couple hundred $$'s should help though...
chadhaajay, does my code help?
i can give you better advice if you explain your EXACT problem better... ad ad more points :-)...
i can give you better advice if you explain your EXACT problem better... ad ad more points :-)...
ASKER
ok, wait let me check the coee
ASKER
Here are my exact requirements.
Please make the database and coding excatly acc. to the needs.
I'll increase the points to triple.
REQUIREMENTS :-
I need an ASP Database page (ACCESS DB) that will have 3 dependant drop down menus. The first drop down picks a song category such as CURRENT SONGS, when a user selects that first dropdown, the 2nd populates with the artists that fall under that category. When the user selects the artist. The 3rd dropdown populates with all of the songs. When a user selects the song the lyrics will then show up below. I also need search capabilities by string (Lyrics will contain artist, album, etc..this is our search field).
I need to be able to cut and paste my lyrics directly from my documents, so this script needs to convert carriage returns into HTML rather than having to manually add it. I will be entering in around 800 songs into this database.
Good Luck..
Ajay Chadha .. :-)
Please make the database and coding excatly acc. to the needs.
I'll increase the points to triple.
REQUIREMENTS :-
I need an ASP Database page (ACCESS DB) that will have 3 dependant drop down menus. The first drop down picks a song category such as CURRENT SONGS, when a user selects that first dropdown, the 2nd populates with the artists that fall under that category. When the user selects the artist. The 3rd dropdown populates with all of the songs. When a user selects the song the lyrics will then show up below. I also need search capabilities by string (Lyrics will contain artist, album, etc..this is our search field).
I need to be able to cut and paste my lyrics directly from my documents, so this script needs to convert carriage returns into HTML rather than having to manually add it. I will be entering in around 800 songs into this database.
Good Luck..
Ajay Chadha .. :-)
ASKER
Please also make for me an admin section for you to make the entries,edit or delete them through a web based interface.
Good Luck..
Ajay Chadha .. :-)
Good Luck..
Ajay Chadha .. :-)
And if something doesn't work as chadhaajay thinks it should work, you'll get response:
"It's not acc."
So, think twice before creating those 'drop down menus'
"It's not acc."
So, think twice before creating those 'drop down menus'
i'll do it for 400 points and an A grade..
ASPGuru, here is the link, so you'll know what Feedback to expect:
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20125907
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20125907
I'll do it for $50 an hour, minimum 4 hours... :-)
Where do I send the contract?
Hey Chad, if your'e that good in VB, why isn't this already done?
Where do I send the contract?
Hey Chad, if your'e that good in VB, why isn't this already done?
>why isn't this already done?
No time, being busy.
>http://wsabstract.com/script/script2/triplecombo.shtml
Still not working. Please send me the complete code at chadhaajay@hotmail.com
Good Luck..
Ajay Chadha .. :-)
No time, being busy.
>http://wsabstract.com/script/script2/triplecombo.shtml
Still not working. Please send me the complete code at chadhaajay@hotmail.com
Good Luck..
Ajay Chadha .. :-)
chadhaajay, why don't you write it yourself?
it shouldn't be a problem... now, as you know how to do the dropdown thing...
it shouldn't be a problem... now, as you know how to do the dropdown thing...
But i didn't wanted a part
Ajay Chadha .. :-)
:-) hehe
Ajay Chadha .. :-)
:-) hehe
ASKER
Thanks man, your help was great.
Ajay Chadha .. :-)
Ajay Chadha .. :-)