I have a base table which I want to create a copy of its structure at runtime to store data specific for a month, yet would have to be able to create the table AND any relationships at runtime. Is this even possible?
its possible with Execute SQL via odbc but not advisable.
Why not just add a date field to the table to distinguish the month?
Retrieving data ...