Multivalues in a table

[rlbroerman]

I can't make a new post so I am doing it as a reply.
I am trying to add a multivalue list box to frmPatients. I want this list
box to save multiple values. See my attempt in the lower right hand corner of
“frmPatientsâ€
I found a way to do this in the Access help under “Add or change a lookup
column that lets you store multiple values†I want this to look like sample
shown in thr Help.
My list of possible pain levels is in the table “tblPainLevel†and the table
I want to store the list of pains is in “CurrentPainâ€
The part that doesn’t work like I thought it should is found in
Add or change a lookup column that lets you store multiple values
Then
Using the Lookup Wizard to create multivalued lookup columns
Then
7. Under Do you want to store multiple values for this lookup?, select the
Allow Multiple Values check box.
The above doesn’t appear in the Wizard.
The beginning of the help says this is new in Access 2007.
Do I need to turn something on to make this work?
Or should I do something completely different?
Thanks for the help.
Rick B

 

[Larry Linson]

It may not be easy to get good answers on this feature (multi-value fields,
euphemism: complex data), because it violates relational database design
principles and, therefore, the most experienced Access developers and users
avoid it (like the plague).

Larry Linson
Microsoft Office Access MVP