1 of 1 people found this helpful
It's hard to say when you don't show what criteria was used in the constrain, but It looks to me that you need to use GTRR before the constrain.
Use GTRR to get all related records, then constrain to get just the category specified.
But it is likely that what you want can be produced without use of a summary report if you stay on the first layout but filter either the relationship or the portal to get just the most recent record of the desired category.
your perform find and constrain find both are restoring a find, so you might want to check what the criteria is for both of these ( I can see one in the screen grab, but I don't know what the other is)... but my bigger question is, why are they separate ? You could put multiple criteria in the one search, right?
What I usually do is to break the searching in to literal steps, like :
Enter Find Mode
Set field <field> = [$_Variable]
this way, I can see what's going on with the searching when I debug.
Thanks Phil for the reply.
If I put the GTRR *between* the FIND and the CONSTRAIN it works as expected.
If I put the GTRR 'above' or 'after' the FIND and CONSTRAIN it fails.
Can you provide some narrative about what is going on?
The other relationship is PK==>>FK. (Just like in the diagram)