R
Rose0815
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.
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.