Can I do this in a Query

[doggo]

Hi,

I am trying to condition a field dependant on the key field value. Here is some example data

TBL1
LINE____VERSION
A_________1.2
B_________1.4
C_________2.0

TBL2
LINE____VERSION
A_________1.2
A_________1.1
A_________1.0
B_________1.4
B_________1.2

So What I am trying to do is make the VERSION field in TBL1 only bring back valid VERSIONS from TBL2 in datasheet view. So when I click on the drop down for the Line A in TBL1 - I can only choose 1.0,1.1,1.2

Any ideas?

 

[SydneyGeek]

Depends how you want to use the data. If you need to be able to pick a VERSION from Table1 and see corresponding values from Table2, you need a form / subform setup.
If you are going to pick a value and then use the matching data for e report, a query could be the way to go.

Denis

 

[doggo]

Can you have a query though that will do that in data sheet view in the table?

 

[SydneyGeek]

You could build a parameter query.
1. Build a query using all the fields from Table 2
2. In Design view, click in the Criteria row of the Version field and type a prompt in square brackets, eg: [Which version do you want to see?]
Every time you run this query, the parameter popup dialog appears. Enter your version and you'll get the result.
There are other ways, based on forms, but this is the quickest to set up.

Denis