greekpatriott
Technical User
Hello,
Can anyone help me find the correct criteria for a query?
If I have three tables say tableA tableB and tableC and a form FormA.
TableA has X and Y values in a field called [PolicyType]
TableB has A, B, C, D, E, and F values in a field called [InsuredItems] and the corresp[onding X and Y values.
TableC is a combination of TableA and TableB for every contract name [ContractNo] which is formed from FormA.
What Criteria should I choose in a query so that when I choose from a form the Policy Type from TableA (comboBox), say X which has the corresponding A and B values of TableB, it will show only A & B instead of all the A, B, C, D, E, and F values????
Can anyone help out? Cheers
Can anyone help me find the correct criteria for a query?
If I have three tables say tableA tableB and tableC and a form FormA.
TableA has X and Y values in a field called [PolicyType]
TableB has A, B, C, D, E, and F values in a field called [InsuredItems] and the corresp[onding X and Y values.
TableC is a combination of TableA and TableB for every contract name [ContractNo] which is formed from FormA.
What Criteria should I choose in a query so that when I choose from a form the Policy Type from TableA (comboBox), say X which has the corresponding A and B values of TableB, it will show only A & B instead of all the A, B, C, D, E, and F values????
Can anyone help out? Cheers