Hey all. Here's the prob:
I am dealing with some offers. An offer composites of many different species and each species composites of many different proposals. (Form with subform and subform within the subform). An offer has a unique name but species can have the same name in different offers.
When I open the final subform to view the proposals, I get all the matching results for all offers despite the fact that I only want the proposals of the current offer for the certain species...
On my relationships I have as primary key both the offer number and the species description...
What am I doing wrong and I can't get the wanted results only?
Hope I am clear enough.
Kyriakos
I am dealing with some offers. An offer composites of many different species and each species composites of many different proposals. (Form with subform and subform within the subform). An offer has a unique name but species can have the same name in different offers.
When I open the final subform to view the proposals, I get all the matching results for all offers despite the fact that I only want the proposals of the current offer for the certain species...
On my relationships I have as primary key both the offer number and the species description...
What am I doing wrong and I can't get the wanted results only?
Hope I am clear enough.
Kyriakos
