Lookup Confusion

[juniorc]

Can some please enlighten me?

I am a bit confused as to why creating lookup fields in my table is such a bad idea. I read "Access: The Missing Manual" as an introduction to Access. I found it very helpful but I did not find in it any admonision against this practice.

 

[John Big Booty]

Perhaps this link will help shed some light on the subject.

 

[Mr. B]

Here is a link that might help you get a better understanding of why it is considered to be a bad idea to define your lookups at the table level.
http://dbageek.blogspot.com/2004/10/access-web-evils-of-lookup-fields-in.html

 

[juniorc]

Thanx Mr B

I C the light.