Multiple Value Lookup field

[Guest]

I need to add multiple values to a look up field and I just found out that
new to Access 2007 I can add multi-values to my look-up fields. I just tried
doing this, but for some reason in the look-up wizard there is no check box
that says "Allow Multiple Values", so then I went to the Lookup tab in the
field properties to see if there was an Allow Multiple Values property and
there was none. Not sure if this would mean anything, but this table was
converted from Access 2003 to Access 2007.
Why do I not have this option and what I can do about it?

 

[Tom van Stiphout]

On Mon, 12 Nov 2007 12:58:03 -0800, Suzanne

This feature only works with accdb - style databases. That's a new
file format introduced with A2007. It does not work with mdb - style
databases of any version. You can convert your db to this new format,
using File > Save As.

-Tom.

 

[John W. Vinson]

I need to add multiple values to a look up field

No. You don't.

If one <whatsis> has many <whozises> and each <whozis> pertains to many
<whatsises>, you need three tables to resolve the many to many relationship. A
classic example is school enrollment. You don't need a multiple value lookup
field to show which classes a student is taking! You instead need tables like

Students
StudentID
<bio info about the student>

Classes
ClassNo
ClassName
<info about the class as a whole>

Enrollment
ClassNo <what class is this student in>
StudentID <who's the student>


John W. Vinson [MVP]

 

[Guest]

Thank you!!

On Mon, 12 Nov 2007 12:58:03 -0800, Suzanne

This feature only works with accdb - style databases. That's a new
file format introduced with A2007. It does not work with mdb - style
databases of any version. You can convert your db to this new format,
using File > Save As.

-Tom.