what is the best way to develop a database for a survey? How should I name the columns in the database? I have an survey to develop and some of the questions have up to 80 answer options + quantity for the options. For example, I have a list of truck models from different manufacturers (eg: John Deere[304, 444, 544, 624...], NewHolland[LW50, LW110, LW130...]. The person filling out the survey needs to be able to select from none to all of items and this would only be question #1. That means if the person filling out the survey select JD 304 and NH LW110 I'll have a total of four entries one for each of the trucks and one of quantity for each of the trucks. If I use a column for each possible answer, I'll end up with about 1000 columns what to me wouldn't be a very well developed database. Anyone has done anything similar? Any ideas? For now this has to be done in Access.
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
maxtrixx 0 Newbie Poster
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
bentkey 10 Posting Whiz
maxtrixx 0 Newbie Poster
OMGALD 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.