Hi guys. I just dived in a made my app (I'm quite pleased with it too, this product creates nice clean results) but now, I discover that I cannot perform simply queries on the data.
All I need is to join
table 1, table 2, table 3, table 4
to create a monster table
I'd like to keep all the data in Knack and do all the other processing I need within the app (just like I would do in excel) but it looks like I'm going to have to take the data out via csv (from all the tables, pull it all together in access or similar before I can use it, which sort of defeats the point).