I am struggling with the join between these two tables.
I have one saved search based on Project and with these criteria
Project Resource Role is Project Manager
Start Date is on or after 1/3/2011
Transaction : Type is Sales Order
and results from both the project and the transaction tables.
And what I get is one row for every project (perfect!)
I just created another saved search based on Project with different criteria and results (less fields from transaction and the field I have used is on the first search too) and this time I'm getting one row for every Sales Order line.
What could be doing this?
I'm going to take the working search and change it one step at a time to the broken one and see what causes this but that'll be very slow and painful.
If anyone knows how the join is supposed to work, I'd be grateful. Thanks, Jean