Table entries from a drop down of all possible queries

[ejhatch]

Hi All,

I am wanting to build a table which consists of all the queries and tables in the database.

I am expecting column 1 to have all the queries and column 2 to contain all the tables that make up the query. So the table will look like this:

Queries - Linked Tables
Query1 - Table1
Query2 - Table1
Query2 - Table2
Query3 - Table1
Query3 - Table4

As you can see a table can be linked to any number of tables.

Now for my actual question. I don't want to have to type in all the queries and tables. I would like to choose any query and table from a drop down of all possible queries and tables that are currently in the database - like a list, where the list contains all the possible values.

I would then select the relevant entry.

Any pointers would be great.

Thanks,

Evan

 

[Smart]

If you go to tools,options,view and place a tick in the hidden objectsbox and the system objects box you will see some system tables two that may be of use are mysysobjects and mysysqueries

 

[ejhatch]

Hi Smart,

Thanks for that. But I would still need to create a new table based on these system tables where the entries in my table would be supplied as a list from these system tables.

I guess the million dollar question is how can I use the contents of these tables as the source of a list in the cells for my table.

Thanks,

Evan