When you make a query condition, you currently have no way of testing the query to ensure it provides the expected results. I suggest a way to create test ttTable data to test the results of query.
Are you talking about BPM queries? You’re suggesting that there be an Analyze tab then?
Something similar, a more watered down version. Perhaps using the term “test ttTable data” was misleading. Really all I care about is the links from my ttTable to other tables.
If I have ttPart and I have it linked to VendPart on PartNum and Company, I like to have a table to enter some values and test the result like:
COMPANY PART
COMP1 PartA
COMP2 PartB
COMP2 PartC
This would allow for quick sanity checks, instead of trying for an hour to figure out a BPM doesnt work because I’m a bozo.
And… the ability to test individual subqueries, pls? (speaking of multi-query BAQs… to clarify).
1 Like