One table queries from another table

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I've created a profile table linked to my customers that
tracks their individual automobile preferrences which may
be more than one profile. I want to cross referrence the
profile table with our vehicle table for matches. How can
one table query another table?
 
I've created a profile table linked to my customers that
tracks their individual automobile preferrences which may
be more than one profile. I want to cross referrence the
profile table with our vehicle table for matches. How can
one table query another table?
Click to expand...

Create a Query joining the two tables (on the make and model fields,
or however you record the preference).
 
John, thanks for the reply... still don't understand your
answer. I want to run a query against my vehicle table
based on more than one profile for each customer. For
instance, Customer 1 is looking for a Ford F150 under
$15,000 as well as a Dodge 1500 under $15,000. Each of
those profiles is its own record to be queried against the
vehicle table. Is this possible without building an
expression into the criteria that point to a form?
 
John, thanks for the reply... still don't understand your
answer. I want to run a query against my vehicle table
based on more than one profile for each customer. For
instance, Customer 1 is looking for a Ford F150 under
$15,000 as well as a Dodge 1500 under $15,000. Each of
those profiles is its own record to be queried against the
vehicle table. Is this possible without building an
expression into the criteria that point to a form?
Click to expand...

Mark, I'm packing to leave for a two-week trip and don't have time to
reply - please post a new thread (maybe with REPOST in the subject).
SORRY!
 
Back
Top