COPY IDENTICAL FORMS TO TABLES WITHOUT RE-DESIGNING

L

laura

I am tying to set up a database with several tables and I want an almost
identical form attached to each one. Can I copy or do I need to create them
through design view again
 
J

Jerry Whittle

I think that you should step back and rethink things. Similar forms assumes
similar tables. Hopefully you aren't creating a table for something like each
division, each year, or something similar. Similar data should all be in the
same table. If you are doing something like a new table for each year, then
next year you will need to create a new table, at least one new form, and the
queries and reports for this table.

It's better to have just one table with a field to identify what makes the
data different such as TheYear or TheDivision. Then you can set up the
queries, forms, and reports to work with this field to get the data that you
want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top