Access 2002 report with autolookup

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

Guest

How to build report with autolookup that fills in fields pulled from table
after I enter a quantity and part number? Like entering an order for a
product by part number.
Thanks
GIrwin
 
Use a query as the source for your report.

In the query, you can include multiple tables, so you can include the field
you want from the lookup table.

If the lookup field is blank in some of your records, use an outer join to
ensure all records are included. See:
The Query Lost My Records! (Nulls)
at:
http://members.iinet.net.au/~allenbrowne/casu-02.html

BTW, the lookup fields often confuse people about what is being stored in
the table and what's going on. If you are interested in why some of us don't
use them, see:
The Evils of Lookup Fields in Tables
at:
http://www.mvps.org/access/lookupfields.htm
 
Back
Top