copying a database

[Aaron]

Hi,
We have a database... with 1 table in it.
we want to add another table to this database.. that is
going to have the same fields as table 1... but different
data in it.

Is there a way to create this new table.... without
starting design from scratch..
Ie) use the field names, and their properties
so we don't have to do them all from scratch again.

-aaron
(e-mail address removed)

 

[Rick Brandt]

Hi,
We have a database... with 1 table in it.
we want to add another table to this database.. that is
going to have the same fields as table 1... but different
data in it.

Is there a way to create this new table.... without
starting design from scratch..
Ie) use the field names, and their properties
so we don't have to do them all from scratch again.

-aaron
(e-mail address removed)

Putting aside the fact that this is usually a bad idea (the tables would be
better combined with a new field added to distinguish the groups) you just
click on the table in the db window and then use the Copy and Paste buttons
in the Toolbar. You have the option of copying only the structure without
the data.