Access DB to track Queries in SQL+ DB

I've recently taken over a nightmare project which is getting worse by the day. The company I work for is implementing a new billing system which utilizes approximately 400 tables. I've been tasked to develop a solution that will ease keeping track of the queries for the billing system.

I currently have set up several tables. One that keeps track of the different tables (approximately 400), another that keeps track of the fields in these tables (joined to the first table using the table name as a primary key, and a third keeping track of the queries.

I have a form to add new queries and manage the queries already entered. It has text boxes for the Query Name and Query Description. There are also two multiselect listboxes, one that has the listing of tables, and another bound to a query that is supposed to pull the fields that go along with the selected tables. Unfortunately I cannot get this functionality to work and store the information properly. I am unsure of how to proceed. Would it be better to create an individual table for each query? That will take up a lot of room, but I could see where it would solve some of my problems.

Any help would be appreciated. I can be reached at higleyjp@gmail.com.

Thanks!
-Justin