I am trying to build a simple database view.
My idea is to fill 3 tables called;
JOB, JOBACTION and ACTION_TRANSACTIONS.
JOB is the main has 1 to many JOBACTIONS. JOBACTIONS has 1 to many ACTION_TRANSACTIONS.
When I select a JOB from the first table I want to see the corresponding JOBACTIONS in the second table ed.
But as simple as it look it isn’t for me.
I did a try with FreeformQuery but this type cannot have a filter.
Then I tried the TableQuery and that results in an error ‘Incorrect syntax near ‘LIMIT’.’
I drives me crazy 
Who has a good working database example with a working filter.
Chris
