Strange field in my table

[Guest]

I had an enormous table that I let the table wizard split into two smaller
tables. But it created a table that is called "Lookup to CDRLDetails".
CDRLDetails being on of the new tables. What is this field. It contails
data that apears in the 'details' table so why should it appear in the other
table. It doesn't make sense to me. Can you explain.

 

[Guest]

I had an enormous table that I let the table wizard split into two smaller
tables. But it created a table that is called "Lookup to CDRLDetails".
CDRLDetails being on of the new tables. What is this field. It contails
data that apears in the 'details' table so why should it appear in the other
table. It doesn't make sense to me. Can you explain.

The "Lookup Field" is a feature - many say a misfeature - introduced with
A2000. Your table actually contains a numeric foreign key to the primary key
of CDRLDetails; what you SEE is looked up from that table, but is not
actually there. See http://www.mvps.org/access/lookupfields.htm for a
critique.

 

[Guest]

Thanks John, sounds like a pretty bad feature to me. How would you suggest I
eliminate the lookup field? Should I recreate the tables manually without
using the table wizard?

 

[Guest]

Thanks John, sounds like a pretty bad feature to me. How would you suggest I
eliminate the lookup field? Should I recreate the tables manually without
using the table wizard?

You can "un-lookup" the field by selecting it in table design view; select
the Lookup tab on the field properties and change it to Textbox rather than
Combo.

I've found that the table wizard is not very clever. You may really prefer
to do your own table normalization. Check out

http://www.accessmvp.com/JConrad/accessjunkie/resources.html

particularly the Database Design 101 link. There's no substitute for a
properly-prepared human mind when it comes to designing database structures!