AutoLookup - beginner question

T

TLC

I'd like to have my Sales form autolookup customer
information (and my child form LineItems look up inventory
information) based on inputting the primary key for each.
Checking Access Help (*laugh*), I see AutoLookup works
only as a query.
Should I assume that I need to create a query for my Sales
and Customer tables and base my Sales form on that? (And
the same for LineItems and Inventory.) Will this still
populate my Sales and LineItems tables?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Can a form linked to an autoLookup query update another table 1
Relationships when one field is an autonumber 1
Add two separate records from autolookup 1
Update multiple record values 1
Update multiple record values in form/query 0
Update multiple record values from form/query 0
Adding data to MS Access from csv file 0

Top