Newbie Post - Query question

[Ty-Uk]

Hi, i'm a newbie so please be gentle

ok, i have 2 tables, one is for part number and product ID and the other has product ID and Vehicle details.

i know how to set up a parameter query but just can't quite get the result i want, which is to set up a query based on the result of the first query.

in short i want to enter a part number and it comes up with the vehicle details.

Many thanks in advance

Ty

 

[jlex]

Create a "relationship" between the tables and use the "input" in the criteria.

 

[Ty-Uk]

Create a "relationship" between the tables and use the "input" in the criteria.

Hi, thanks for the prompt reply - any chance you could be a bit more specific ?

i've created a relationship between the two tables linking the two product IDs - but what do i do now ?

Thanks again

Ty

 

[jlex]

in the part number "criteria" field in query design view have something like:
(you need the square brackets)

[Which part number?]

This will give you a input box. Make sure you have all the other fields you need to see. The query will only select the results that match your entered part number.

Jen

 

[ranjah]

try this

I am attaching a sample database try and see if that helps you.
more questions just ask.

 

[Ty-Uk]

Brilliant Guys - i used a mixture of advices and i've got it to work - ranjah, the file came in very useful and was the last piece of the jigsaw.

Thanks once again - much appreciated

Ty