Lookup Columns

[Emma]

Hi I'm trying to create a drop down where the user can select more then one
option. Right now I have a column called Status in my main table I created a
lookup column called Status Lookup which pulls the information from a table
called status which holds things like active inactive etc.. So now I've put
the status lookup field in the form and there's no checkbox list it's just a
normal drop down. Does anyone know how to get the checkboxes or even the
Allow Multivalue to come up?

 

[Graham Mandeno]

Hi Emma

Is this Access 2007 or an earlier version?

 

[Emma]

Yes it's 2007

Hi Emma

Is this Access 2007 or an earlier version?

--

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi I'm trying to create a drop down where the user can select more then
one
option. Right now I have a column called Status in my main table I created
a
lookup column called Status Lookup which pulls the information from a
table
called status which holds things like active inactive etc.. So now I've
put
the status lookup field in the form and there's no checkbox list it's just
a
normal drop down. Does anyone know how to get the checkboxes or even the
Allow Multivalue to come up?

 

[Graham Mandeno]

Hi Emma

Unfortunately, if you want to use that very nice multi-select combo box in
Access 2007, you need to set up a multi-valued lookup field in your table.
I don't use these myself, as I firmly believe they are the work of the
devil, and they contravene some of the most basic rules and principles of
database design.

However, if you want to use them, I suggest you search the online help for
"multivalued" and then follow the links to "Add or change a lookup column
that lets you store multiple values" and "Use a list that stores multiple
values".

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Yes it's 2007

Hi Emma

Is this Access 2007 or an earlier version?

--

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi I'm trying to create a drop down where the user can select more then
one
option. Right now I have a column called Status in my main table I
created
a
lookup column called Status Lookup which pulls the information from a
table
called status which holds things like active inactive etc.. So now I've
put
the status lookup field in the form and there's no checkbox list it's
just
a
normal drop down. Does anyone know how to get the checkboxes or even
the
Allow Multivalue to come up?