Strange field in my table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Freehal04 said:
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.
Click to expand...

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.
 
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?
 
Freehal04 said:
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?
Click to expand...

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!
 
Back
Top