lookup field to update a table for use by parameter query

[Guest]

I created a sales table with all information relating to every sale,
including customer number and product type. Now, I have to add a location
based on the customer number. My first thought was to create a separate
table that holds both the customer number and their location. Then maybe
create a relationship based off the customer number. If I have to create a
parameter query that asks the user (from drop down menu) first location, then
product type...how do I do that if the sales table does not have location as
a field? Please help.

 

[Steve Schapel]

Rose,

I think your idea is a good one. I thought you might already have a
Customers table, with Customer Number, Customer Name, Phone, etc, and
other information related specifically to the customer. So if you need
a Location field, and there isn't already one there, then you can just
add it (and obviously enter the location information for all existing
customers). You would not put the Location field in the Sales table.
When you enter the Customer Number in the Sales table for a particular
sale, you automatically know the Location, based on the Location in the
Customers table for that particular customer. Whenever you need to see
the Location for the Sales, on your forms or reports, you would use a
Query that includes both the Sales table and the Customers table.