I'm sure there is an answer to this question on this board some where but I haven't found it.
Each month I add a new table to my backend database. The frontend database allows the user to select any 2 tables and get the reasons for variance. Usually I run current month to prior month and current month to first of year. But every once in awhile, some manager wants quarterly reports. So I keep all months in the backend.
I want to have the frontend link to all tables in the backend with the name format of yyyy-mm-dd without me having to create that link.
How do I do this?
TIA,
me
Each month I add a new table to my backend database. The frontend database allows the user to select any 2 tables and get the reasons for variance. Usually I run current month to prior month and current month to first of year. But every once in awhile, some manager wants quarterly reports. So I keep all months in the backend.
I want to have the frontend link to all tables in the backend with the name format of yyyy-mm-dd without me having to create that link.
How do I do this?
TIA,
me