pbuethe
Returning User
- Local time
- Yesterday, 22:12
- Joined
- Apr 9, 2002
- Messages
- 210
I have a lookup table with a compound primary key: CaseNbr and ReviewLevel. An example of the data in these fields is:
CaseNbr ReviewLevel
1 PRA
1 MRA1
2 PRA
3 PRA
3 PC1
3 PC2
4 PRA
4 PC1
4 MRA1
5 MRA1
5 MRA2
6 PC1
I have a query to select cases with a “PRA” review level with other criteria.
I have a form with a subform which is based on another query. The second query is based on the first query linked by a left join to another table which also has CaseNbr and Review Level in the PK. However, they are linked only on CaseNbr.
I have an option group on my form which I am trying to program to filter the subform/report.
Four of the 5 options select cases with an “MRA1” review level with other criteria and display fields from the MRA1 review level (from the 2nd table) on the subform and on a report. These are working.
The other option needs to find the cases that do not have an MRA1 level.
With the example above, the filter should return cases 2 and 3.
Thanks for your help.
CaseNbr ReviewLevel
1 PRA
1 MRA1
2 PRA
3 PRA
3 PC1
3 PC2
4 PRA
4 PC1
4 MRA1
5 MRA1
5 MRA2
6 PC1
I have a query to select cases with a “PRA” review level with other criteria.
I have a form with a subform which is based on another query. The second query is based on the first query linked by a left join to another table which also has CaseNbr and Review Level in the PK. However, they are linked only on CaseNbr.
I have an option group on my form which I am trying to program to filter the subform/report.
Four of the 5 options select cases with an “MRA1” review level with other criteria and display fields from the MRA1 review level (from the 2nd table) on the subform and on a report. These are working.
The other option needs to find the cases that do not have an MRA1 level.
With the example above, the filter should return cases 2 and 3.
Thanks for your help.