I have two different tables where am trying to retrieve data, now can i specify these two tables as in search criteria

[thotapallavi]

Hi ,

Am able to display data from two different table in the form of chart and in table of content as well. But I would like to make those two different tables to be displayed in Search box and if possible we can give a choice for the user to select the table in the search box and display data based on selection to the chart and table as well. How is it possible to make it?

As suggested in my previous question am able to display data from multiple tables using Flag with the code, but would like to see those two tables in search box

Table1:

LOAD Year,

          Quantity_Sold,

          1 as Flag

From Source1;

Concatenate (Table1)

LOAD Year,

          Quantity_Sold,

          2 as Flag

FROM Source2;

Thanks for the team in advance