
I've set up the query with a few different joins. 
Where you see the value hardcoded it's supposed to be a value coming in from the client side.
I tried hard coding as I wanted to see if it was a problem with the query and I'm no further in understanding why this is happening. 
You can see from the image the table holds the values I've hardcoded. 
If you look at the debugger the recId = 0 in each joined table I called. 
Is there a problem with my join somewhere to where I won't even get the value for the first buffer variables?