473,321 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

How to question: Added new values to dropdown lists & database

This is my attempt to rephrase a question I asked earlier that got no
response. I suspect it was my poor/unplanned wording. Here is another
attempt:

I have a form with some drop down lists. I would like the user to be able
to start filling in the form, then get to one of the dropdown lists (ex:
Service Type) and realize that the dropdown list does not contain the entry
that they need. So next to the Service Type drop down list is a
link/image/button/whatever that they can click to bring up a new window ( or
???) to add that new Service Type item. When they save this new Service
Type item's information, it will be added to the database ServiceTypes table
in the db, the Add Service Type window will close, and the form that they
were originally filling out will be preserved, but refreshed to show the new
service type in the drop down list.

I'm not asking for exact code necessarily, just some general concepts/links
on how others have accomplished it. I am looking for a more elegant way
than saving each field's data into some temp storage and refreshing the
whole page to add the new service type item, then returning the user back to
the original form and re-filling all of the fields with the stored values.

Thanks
Chris
Nov 17 '05 #1
2 3606
Sounds like you'll be needing to use some client side javascript.
You can open a new window using javascript such as this:
a=window.open('http://localhost/TestWebApp/Test.aspx','_new')
There are all kinds of options for setting window properties such as window
size and toolbar visibility.
Here's more info:
http://msdn.microsoft.com/workshop/a...ods/open_0.asp

From that new window you can reference the original parent window with
thisjavascript reference:

window.opener

Here's more info on that:
http://www.mozilla.org/docs/dom/domr...dow_ref77.html

--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net
"Chris Becker" <sl*****@hotmail.com> wrote in message
news:O6**************@TK2MSFTNGP10.phx.gbl...
This is my attempt to rephrase a question I asked earlier that got no
response. I suspect it was my poor/unplanned wording. Here is another
attempt:

I have a form with some drop down lists. I would like the user to be able
to start filling in the form, then get to one of the dropdown lists (ex:
Service Type) and realize that the dropdown list does not contain the entry that they need. So next to the Service Type drop down list is a
link/image/button/whatever that they can click to bring up a new window ( or ???) to add that new Service Type item. When they save this new Service
Type item's information, it will be added to the database ServiceTypes table in the db, the Add Service Type window will close, and the form that they
were originally filling out will be preserved, but refreshed to show the new service type in the drop down list.

I'm not asking for exact code necessarily, just some general concepts/links on how others have accomplished it. I am looking for a more elegant way
than saving each field's data into some temp storage and refreshing the
whole page to add the new service type item, then returning the user back to the original form and re-filling all of the fields with the stored values.

Thanks
Chris

Nov 17 '05 #2
I like to keep that kind of stuff on the same page if I
can.

you can put the "add new thing" controls next to the drop
down, with visible set to false. Clicking the icon makes
it visible. They add the info, click the Add button in
that section, and you bind the drop-down to the table, now
with the new value.
-----Original Message-----
This is my attempt to rephrase a question I asked earlier that got noresponse. I suspect it was my poor/unplanned wording. Here is anotherattempt:

I have a form with some drop down lists. I would like the user to be ableto start filling in the form, then get to one of the dropdown lists (ex:Service Type) and realize that the dropdown list does not contain the entrythat they need. So next to the Service Type drop down list is alink/image/button/whatever that they can click to bring up a new window ( or???) to add that new Service Type item. When they save this new ServiceType item's information, it will be added to the database ServiceTypes tablein the db, the Add Service Type window will close, and the form that theywere originally filling out will be preserved, but refreshed to show the newservice type in the drop down list.

I'm not asking for exact code necessarily, just some general concepts/linkson how others have accomplished it. I am looking for a more elegant waythan saving each field's data into some temp storage and refreshing thewhole page to add the new service type item, then returning the user back tothe original form and re-filling all of the fields with the stored values.
Thanks
Chris
.

Nov 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Joseph Barron | last post by:
Here is a SIMPLE problem that I'm trying to solve. It works in Netscape 6.2, but IE6 gives ""No such interface supported." Below are page1.htm and page2.htm . In page1.htm, there are two...
0
by: Toonman | last post by:
I have a webpage with a <form> consisting of a large table grid of dropdown lists used to make changes in a database. Some of these dropdown lists have the same value. I'm trying to make it so...
0
by: SJM | last post by:
There is a database which has combo boxes to allow users to select values from pre-set lists of common specifications. The form allows users to enter values that are not in the dropdown lists....
3
by: Jon | last post by:
I am using cascading dropdowns, where the selection in one determines what fills another. In regular ASP I simply loaded a giant dataset into javascript array and when you clicked on one dropdown,...
29
by: MP | last post by:
Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this...
27
by: Chad | last post by:
The problem is: Write a recursive version of the function reverse(s), which reverses the string s in place. In "The C Answer Book", Second Edition, near the bottom of page 95, the authors say...
2
by: Micela | last post by:
Hi, Please help me out in this task. I have a filed in the database of datetime. and 3 dropdown lists in the page. Im using Asp.net with VB coding. The three dropdown lists are 1.for date...
2
by: assgar | last post by:
Hi Developemnt on win2003 server. Final server will be linux Apache,Mysql and PHP is being used. I use 2 scripts(form and process). The form displays multiple dynamic rows with chechboxs,...
7
by: yanni | last post by:
I have some thing like this: <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="uxTestDropDownList" runat="server" /> <asp:Button ID="uxSubmitButton" runat="server"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.