Forum Discussion
Search Two Tables Based On Multiple Criteria
Hi All, I have been stuck on this for awhile and any help would be appreciated: On one table I have ProjectID WorkstreamID Value 59 125 2 98 6 1 55 9 1 8 100...
v-yalanwu-msft
Community Support
Community SupportHi, Longhorns2013 ;
When we select Project 1001 and 98 from a dropdown filter , the value why is 11 rather than 17(6+6+5)?
can you provide the logic about those result and your Workstream table?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You are correct! Sorry about that, I missed the first 98 in my example.
So if I select a project, in theory I want everything related to that project and if I select a project and associated workstream, I just want that specific workstream.