Call Queries

Hi All,

I have a need to create a dashboard and from there I would like to call different queries using a command button. Also this dashboard should create a seemless view of results of queries coming from 3 queries. Any ideas?

1. I am planning use overlapping layers and position it in such a way it will fit and make all the layers visible at the same time. Each layer will show the result from 1 query.

2. I have used hyperlink option to connect to a PDF but never used it for almost like a jump to query scenario.