473,396 Members | 1,884 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,396 software developers and data experts.

any ideas please?

27
in my database one of the fields will be a field to ask questions. i want a way so that the user can enter a question in the field, and if they have another question they can go on hwo can i do this?
Jul 13 '07 #1
5 1385
Rabbit
12,516 Expert Mod 8TB
What do you mean by "go on"?
Jul 13 '07 #2
vibee
27
they can ask another question
Jul 16 '07 #3
It sounds like a cascading combo box issue. Do you have a list of questions already prepared and entered in a table??
Are you wanting to filter certain questions based on the first question asked??
Jul 16 '07 #4
vibee
27
no i dont have a list of questions, these questions come up as more detail about the product is recieved, and i was wondering if there was a way where the user had a choice to ask a second or third question, where the field would be automatically created, or do i have create all the fields?
Jul 16 '07 #5
FishVal
2,653 Expert 2GB
no i dont have a list of questions, these questions come up as more detail about the product is recieved, and i was wondering if there was a way where the user had a choice to ask a second or third question, where the field would be automatically created, or do i have create all the fields?
An old good idea.
For normalized db one field would be enough. Is this normalized one?

I mean:

- unnormalized (one table)
tblSingleTable
keyProductID
txtQuestion1
txtQuestion2
txtQuestion3
.....
txtQuestionN
....

- normalized
tblProducts
keyProductID Primary key (PK)
......
tblProductQuestions
keyQuestionID Primary key (PK)
keyProductID Foreign key (FK) from tblProducts
txtQuestion
......

tblProducts is in one-to-many relationship with tblProductQuestions, this allows to add as many questions to each product as you want (a real quantity is limited by 2G db size)
Jul 16 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: FLEB | last post by:
I like PHP for its excellent inline integration into standard HTML files, but I like Perl for its quick-moving syntax and simpler data-processing. To resolve this deep-seated inner turmoil (oh, the...
0
by: Gennadiy Tit | last post by:
I have to load 1700 records from DB into tree view (NOT LIST VIEW). I have tried to load it with locking the windows and control and other stuff, but it not givingme the result that I need. It...
14
by: David MacQuigg | last post by:
I am starting a new thread so we can avoid some of the non-productive argument following my earlier post "What is good about Prothon". At Mr. Hahn's request, I will avoid using the name "Prothon"...
3
by: Brian Piotrowski | last post by:
Hi All, I'm trying to run a simple query from an ASP page. I want the query to select each individual field in a table and compare it to another table. If the value doesn't exist, I want it...
3
by: Slash | last post by:
Hello everyone I'm looking for seminar topics (and project ideas too) for my final year in Computer Engineering. I'm considering doing something on C++/Linux, considering that I love it so much...
1
by: Az Tech | last post by:
Hi people, (Sorry for the somewhat long post). I request some of the people on this group who have good experience using object-orientation in the field, to please give some good ideas for...
3
by: kaosyeti | last post by:
hello. i want to first say that i welcome anyone's ideas for this post. please feel free to throw your 2 cents in. i have a db that i'm finishing that i'm going to be giving to others to use....
1
by: Brian Piotrowski | last post by:
Hi All, I'm trying to run a simple query from an ASP page. I want the query to select each individual field in a table and compare it to another table. If the value doesn't exist, I want it...
3
by: pitachu | last post by:
hi all, I need some high level and efficient ideas on how caching should be designed in the scenario below. The application and the cache will most likely be in VB.NET. I have a central...
0
by: bcannon | last post by:
At Guido's suggestion, a new mailing list has been created named Python-Ideas (http://mail.python.org/mailman/listinfo/python-ideas). This list is meant as a place for speculative, pie-in-the-sky...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.