By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,946 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,946 IT Pros & Developers. It's quick & easy.

Need best way of building a table with numerous fields

P: 33
I'm running Access 2003 on Windows XP.

This is more of a developmental/implementation type of question. I have a form which requires answers to 35 different questions. All questions are answered by checkbox and two text fields. This makes for a total of 105 fields (35*3=105) just for question answering. Since all questions require the same Yes/No answer and two text fields, is there a way I can cut down the size of my table?

Should I create a second table to house the answers to each question? The fields in the secnod table could be: Link_ID (to link to the record on my main table), question number, Yes/No field, and two comments boxes. Does this make sense from an implementation perspective, or is there a better solution? I figure that I can add the answers to the secondary table using SQL, so that all the answers could be added to the second table upon form submission. I could then use queries to remerge the data as needed.

Is it better to create a second table or to just use one really LARGE table?
If creating the second table is better, how would I populate the data back into the form’s fields in case a record needs to be updated?

Any advice/direction is greatly appreciated!

Thanks!

-Kyle
Oct 29 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Here's a link to Duane Hookums’ Survey Database, which may give you some ideas:

http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

Please honor the caveat from his site:

At Your Survey is provided for educational purposes only. Steal ideas and methods but not the whole of the application. You may not distribute this application except upon agreement from Business Results. This runs in Access 2000, but undoubtedly will run in later versions.
Welcome to Bytes!

Linq ;0)>
Oct 29 '08 #2

P: 33
Linq,

I'm speechless. This thing is amazing! Thanks. :)

-Kyle
Oct 29 '08 #3

Post your reply

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