Lookup fields in tables

[TeeSee]

"I strongly recommend that you do NOT use Lookup fields in your
tables. Lookup fields are unnecessary in tables, because the user
should be entering and reviewing data in forms, and they cause
problems in other database objects such as queries and forms."

The above is an excerpt from an "Access Tips" page. I have seen this
kind of statement several times and I really don't understand it.

I use a combo box for a lookup to show a list of vendor ID codes that
come from the tblVendors table. Is this what is meant by a "lookup
field in a table"? If not how do you perform a "lookup field in a
table"

Please clarify this for me.

 

[Beetle]

A lookup field is when you use a combo box in a table. Combo boxes
are perfectly acceptable, and commonly used, in forms, but they should
not be used in tables. See this link for more info;

http://www.mvps.org/access/lookupfields.htm