Look Up Tables

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

Guest

I have a form for order entry. Most of the information will be coming from
hard copy. I have products, shipping methods, payments methods to name a
few. Does anyone have any opinions as to whether look up tables are a good
choice or not? I have just read in one of my sources that he does not advise
look-up tables.

?????
 
Do not use lookup table but use table - query - form for inputting data. In
the form use combo boxes with autoexpand property to Yes. Have the combo box
source a totals query from your table to have everything ever entered
available.
 
I have a form for order entry. Most of the information will be coming from
hard copy. I have products, shipping methods, payments methods to name a
few. Does anyone have any opinions as to whether look up tables are a good
choice or not? I have just read in one of my sources that he does not advise
look-up tables.

?????
Click to expand...


I suspect that your source was not objecting to lookup tables but to "lookup
fields" in tables. Lookup Tables are universal in any practical Access
database! By all means you should have a table of Products, a table of
Shipping Methods, etc.

The "lookup fields" issue is discussed at
http://www.mvps.org/access/lookupfields.htm. Microsoft added a feature (many
call it a misfeature) in A2000 allowing you to put "lookups" into table
datasheets. This can have some very limited usefulness, but it's VERY limited;
what you should do instead is create Forms to do all your data entry - and put
combo boxes ("lookups") on the Form. It is NOT necessary to have a "lookup
field" in a Table in order to do so.

John W. Vinson [MVP]
 
Back
Top