G
Guest
I'm considering splitting my DB into FE and BE. The FE will have queries
that create new tables daily, weekly, and monthly (standardized table names
with changing date tags--i.e. Daily03312006, Daily04032006) so the FE is at
risk of growing rapidly. I would like to set up queries in the FE to create
the new tables, export them to the BE then link the newly added BE tables
back to the FE. The part I can't figure out is how to automate the linking
of the new tables to the FE.
Is this a pipe dream or does anyone have suggestions?
that create new tables daily, weekly, and monthly (standardized table names
with changing date tags--i.e. Daily03312006, Daily04032006) so the FE is at
risk of growing rapidly. I would like to set up queries in the FE to create
the new tables, export them to the BE then link the newly added BE tables
back to the FE. The part I can't figure out is how to automate the linking
of the new tables to the FE.
Is this a pipe dream or does anyone have suggestions?