Multivalued Lookup Field

W

willm16

I'm making a table and one field needs to be a multivalued lookup field. I
don't want this to be like a regular lookup field where you can only select
one thing. I want to be able to select multiple choices using checkboxes (all
in one field). I DO NOT want to get my choices from another table, but
instead, I want to type the choices in myself.

Can someone please give me step by step instructions on how to do this?
Thank You!
 
M

Maurice

Well, the multivalued lookup field doesn't have many friends among the people
here but try something like this:

1. In the table create your field and choose the lookupwizard as the datatype
2. The wizard will start
3. Choose, I will type in the values I want
4. In the next page type in the number of columns you want to see e.g. 3
5. Type in the data in the designated fields and choose next
6. In the next page choose your option (store data for later use... or not)
7. In the next page check the checkbox "Allow multiple values"
8. When you open the table you'll see you can choose multiple values in that
field.

hth
 
W

willm16

I got it to work....Thanks a lot!

Maurice said:
Well, the multivalued lookup field doesn't have many friends among the people
here but try something like this:

1. In the table create your field and choose the lookupwizard as the datatype
2. The wizard will start
3. Choose, I will type in the values I want
4. In the next page type in the number of columns you want to see e.g. 3
5. Type in the data in the designated fields and choose next
6. In the next page choose your option (store data for later use... or not)
7. In the next page check the checkbox "Allow multiple values"
8. When you open the table you'll see you can choose multiple values in that
field.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top