Lookup wizard

[rob8718]

Hi i'm new to access and I'm trying to use lookup wizard on a table but at the very end it gives me a message of unable to save table. What should i do?

 

[GinaWhipp]

Welcome to the Forum!

Well, can't tell you why you are getting that message I can say do not use Look-Ups in Tables. Have a look at...

Lookup fields in tables are a feature provided by Microsoft that causes a lot of confusion, see…
http://www.mvps.org/access/lookupfields.htm

You can use what we like to refer to as *Look-Up tables*. Look-Up Tables are simply regular tables that hold lists of values for use in Combo Boxes on forms.

That said, if you still want to use them, please post the exact error message you are getting and exactly what happens along with your Access version.

 

[themurph2000]

Welcome to the Forum!

Well, can't tell you why you are getting that message I can say do not use Look-Ups in Tables. Have a look at...

Lookup fields in tables are a feature provided by Microsoft that causes a lot of confusion, see…
http://www.mvps.org/access/lookupfields.htm

You can use what we like to refer to as *Look-Up tables*. Look-Up Tables are simply regular tables that hold lists of values for use in Combo Boxes on forms.

That said, if you still want to use them, please post the exact error message you are getting and exactly what happens along with your Access version.

I can certainly understand not wanting to use them. But my problem is this: I need to make a list from which a user can select multiple items and the values of those are placed in a single field in the table (separated by commas). The research I did online was pushing me towards using a Lookup Wizard in the table for that field. What I was trying for was to use a table for the list of values (using a numerical field as a primary key) and store the numerical value in the field rather than the long statement attached to each one. In a form, would an option group allow multiple selections and place those selections in a single field, or do I have to go in a different direction?

(Just have to remind myself this beats the hell out of unemployment.)

EDIT: I figured it out. I was hiding the key column, which was the column I wanted to store. In the words of Emily Litella, never mind! :banghead: