Analyze Table Wizard error converting to Lookup field

[rdaiuto via AccessMonster.com]

I was trying to make my database more efficient so I ran the "Analyze Table"
database tool.
I chose my "tblContacts" table and drag and dropped the "AD Canonical Name"
field from the tblContacts table since it is often repeated, into a new table.
When I ran through the wizard it gave me the following error:
"Multi-valued fields are not allowed in SELECT INTO statements"
The AD Canonical Name field data looks like this:

Offshore\Users\ABC\Corporate\Domain
Onshore\Users\123\Corporate\Domain
Users\ABC\Contractors\Domain

Does the format of the field have anything to do with my error?

Since there are 25,000 contacts I want a solution that won't cause me to lose
the entries I currently have in this field once the Lookup field is created.

Any help would be great!

 

[Jeff Boyce]

Search this newsgroup for the considerable consensus AGAINST using the
lookup data type in a table.

Access tables store data, Access forms display it. Use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[rdaiuto via AccessMonster.com]

What is the better solution?

Search this newsgroup for the considerable consensus AGAINST using the
lookup data type in a table.

Access tables store data, Access forms display it. Use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I was trying to make my database more efficient so I ran the "Analyze
Table"

[quoted text clipped - 19 lines]

Any help would be great!

 

[Jeff Boyce]

Forms.

Regards

Jeff Boyce
Microsoft Office/Access MVP

What is the better solution?

Search this newsgroup for the considerable consensus AGAINST using the
lookup data type in a table.

Access tables store data, Access forms display it. Use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I was trying to make my database more efficient so I ran the "Analyze
Table"

[quoted text clipped - 19 lines]

Any help would be great!

 

[John W. Vinson]

What is the better solution?

Storing the data in tables (WITHOUT lookup fields); editing the data with
Forms based on the tables, or (more commonly) based on a Query selecting data
from the table. You can put combo boxes on the form to allow "lookups" without
there being lookup fields in the table.