Multivalued Lookup Field

[Guest]

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!

 

[Guest]

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

 

[Guest]

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

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