I want to be able to have my query give me all items that have a "PP" as a type but not disregard the other types that same part number uses. All i can seem to do is just give me all the parts that have a "PP" as a type but not give me the other types it has as well. I know this is probably not a good explanation but i cant seem to think of any other way to explain. If you understand what i am saying please help me.
criteria question (1 Viewer)
- Thread starter cliff7376
- Start date
[item] is one field and [type] is another field. It is a one to many relationship. There is one [item] and many [type] associated with it. What i want to do is give me the [item] that have a [type] "PP" associated with it but i also want the other [type] that are associated with that item as well. Is there a way to do this?
David R
I know a few things...
- Local time
- Today, 08:16
- Joined
- Oct 23, 2001
- Messages
- 2,633
I did this with two queries.
Query1:
Source: tableTypes
[ItemField] from tableTypes
[TypeField] from tableTypes, criteria: "PP"
(or Forms!SearchForm.textBox, or whatever)
Query2:
Source: whatever data tables you need, plus Query1.
Draw a line from Query1 to the matching field in your main table. You don't need to actually include any fields from Query1 in your results, it just needs to be there to limit the data.
Try running Query2 now and see what happens.
Good luck,
David R
[This message has been edited by David R (edited 04-22-2002).]
Query1:
Source: tableTypes
[ItemField] from tableTypes
[TypeField] from tableTypes, criteria: "PP"
(or Forms!SearchForm.textBox, or whatever)
Query2:
Source: whatever data tables you need, plus Query1.
Draw a line from Query1 to the matching field in your main table. You don't need to actually include any fields from Query1 in your results, it just needs to be there to limit the data.
Try running Query2 now and see what happens.
Good luck,
David R
[This message has been edited by David R (edited 04-22-2002).]
