Hi,

I have a database where the same table is created many times using
different names (defined by the user).

If I have a table named "template", can I just create a new table
(named by the user) using the definition in the "template" table?

i.e. if I type in the name of the new table as "fish", I want it to
create a new table named "fish" with template's table definition.

Was wondering if this could be done...

Thanks,

Kevin

Kevin
I think if your going to use this you don't see the storms on the horizon.
After this database has been in heavy use for, lets say, 6 months and
an frustrated user comes to you and tells you they can't remember the
name they gave to a table and "Will you find it for me?" You'll be doing
just like your example. ie: Going Fishing. 8^{
I have run into this with Word Processing Documents and it drove me
to what I am today: Retired and Retarded 8^) and to confused to
realize it. HAHA!!!!
Have Fun....
Don

Once again, thanks for the help... I got it working with the SQL
statement... I hear you when you say that it may cause problems, but
in this case.. I think it's warranted..

I have a database with a financial section, and the user is allowed to
create different accounts.. I figured it would be better to have each
account as it's own table... then they can delete only that table and
whenever work is being done, none of the other tables are being
touched.. they access the accounts from a picklist (listing each of
the tables - you helped me on this one also).

Thanks again...

Kevin

You might try using a make-table query