Any advice?

Thomas, 
That was a final layout I just created to show you guys but looks like I screwed up a little bit. But the end result should be 26 Unique...

Here what the end result should look like from above sample data. 26 Unique IDs. Here is the logic I need to pick to right info
 It could possible one...

I am sorry. It was TYPO. I will fix the comment. It should be "It is not behaving as suppose to be"
Sorry about that!

Hi Ken,
Thank You. That query works perfectly in my above example. I just Pull LIVE data below.
I tried to use above query on below LIVE data and...

I apology if my question or comments are not clear. Let me try one more time. I want Unique ID and Client ID. To Pick the right Client ID the logic...

Hi Pietinden, 

Thank You for your reply. However, I want the ID to from the result set, Once I get the ID. The step I am linking other table...