If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table field length limit alternative
Hi,
I need a table which will hold a user's answers to about 27 survey questions. Multiple users will use the database to enter responses for each question. My problem is that some questions are more than 255 characters long and it isn't practical to use such long field names to hold the actual question in. Most of the questions require responses that are either memos, dates, numbers and yes/no fields. What would be the best way to design a table that can hold 27 questions and the multiple responses for each? I'd like the possibily to easily make changes to the questions, add more questions later. Any suggestion would be much appreciated |
Thread Tools | |
Display Modes | |
|
|