Use a Command Button to make a new Table???

[ajh2014]

Is it possible to use a command button in Access 2010 to build a new table? If so are there any examples? I used the search function on the forum and also googled and received no responses. Thanks!

[ranman256]

Is it a copy of an existing table?

Otherwise it is useless ...you must know every field, and each data type.

[ajh2014]

The new table will be for new equipment added to a database. There are other tables like it in the database with the same fields. Basically I have about 200+ different types of equipment that I want to put into seperate tables so that I can use cascading combo boxes. One combo box to select the equipment type and the other, which will auto filter to that specific type of equipment, will be to select the specific piece of equipment based on a serial number. Is there an easier way to do this? Thanks ranman!

[ranman256]

You wouldnt make a new table, you would make new records in the same table.
I have an equipment db.
It has the table tEqup and handles all types of stuff.

EqType ; (PC,modem, laptop, monitor, etc)
Manuf
Model
SerialNo
PurchDate
Notes
WarrantyDate
etc.


Do not make separate tables. You want to be able to search, so 1 table.