I have created a lookup column in Access 2007 but I need for people to be
able to choose more than one option on this one field. Does anybody know how
to do this. What im asking for is really a "please tick all appropriate
answers" field.
Then you need another table.
Lookup fields are VERY limited. A2007 has a "multivalue field" but it's also
very nonstandard in database terms, and very limited.
If you have many "customers" and many "answers", and each customer can select
multiple answers, then you need THREE tables: Customers (with a CustomerID as
a primary key, and information about the customer as a person); Questions,
with one row per question; and Answers, with fields CustomerID, QuestionNo,
and Answer, one row per answer. A Form with a Subform will let you enter data
into this.
Check out the tutorials on how to design databases at:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
