The "2nd Access Web Commandment"

[RickDB]

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

Why noT?

I thought lookup fields (IF I am understanding what they are referring to in the first place) was how you "lookup" information in a foreign table, right?

What method should be used in its stead?

If I have a combo box or a list box, how do I have the data stored in another table be the results which display in the drop down box? Now I am getting more cornfused.

 

[Banana]

They explained it....

You create a table and use it as a lookup table. Also, create a combobox with a wizard and look at how it configures the properties (look at column counts, width and the data rowsource).