Can a large data pivot grid pull from multiple tables?

Hi,

I have had this particular use case.  What I have have done is create a View in SQL that uses a union query to join my datasets.  Obviously in this case your tables will need to have the same fields.

Alternatively if you were wanting to supplement information in your primary table, you could this with a join to the additional table's fields.  Again I would do this as a view.

The view itself should be accessible in the data adaptor.