Autolookup

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

Guest

I'm having a VERY difficult time in using autolookup. Help on this feature is limited for a new user. Could someone PLEASE e-mail all steps/example on this feature. As a former user of Paradox, this feature was VERY easy to use

Thank you very much!
 
Kenneth: Good old Paradox! I remember that feature, too. Well it's not so
difficult in Access as all that. Sing along:

1-Create two tables: Customers, Orders.
2-Customers table has two fields: CustomerID (AutoNumber, Primary Key),
CustomerName (Text).
3-Orders table has three fields: OrderID (A/N, PK), CustomerID (Number,
Field Size=Long Integer), OrderDate (Date/Time).
4-Set up a 1-to-many relationship on CustomerID with the Customers table on
the "1" side.
5-Enter one or two records in the Customers table. Their IDs should be 1 and
2.
6-Create a query that includes both tables.
7-Add the following fields to the query: OrderID, CustomerID (from ORDERS),
CustomerName, OrderDate.
8-Run the query (no records retrieved).
9-In the first record, enter CustomerID 1 and press Tab or Enter. Access
will fill in the Customer Name.

That's all there is to it.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

Kenneth said:
I'm having a VERY difficult time in using autolookup. Help on this feature
Click to expand...
is limited for a new user. Could someone PLEASE e-mail all steps/example on
this feature. As a former user of Paradox, this feature was VERY easy to
use.
 
I depends on what kind of lookup you need.

Often, we want to store the partID, but display the part description.

I would suggest in the above case is use the combo box wizard. The result
will be a control that shows the lookup text value, but actually stores the
partID. (so, the contorl will look-up the text). This is takes no
code...and is only a few mouse clicks if you use the wizard to add the combo
box for you.
 
Back
Top