How to create a master form or table?

[Guest]

Dear friends,
I have a certain database where I have to create tables and forms

containing information of different catogories, but the fields and

field lables are all the same and they also share the same type of

visual basic script.

Now what can I do so that each new table or form which I create

should have the settings of my master table or form.

I hope you will help.....

 

[Jeff Boyce]

I'm somewhat confused by the terminology. You posted in a newsgroup that
supports Access forms, but your question refers to "new tables".

From your description, it sounds like you are creating new tables patterned
after a "master table". In a well-normalized relational database, you would
not be creating tables on-the-fly, they would already be created and you
would be adding data.

If you were working with a spreadsheet, creating "duplicate" 'sheets might
be about the only way to handle some situations... but Access is not a big
spreadsheet!

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thank you.
My problem is associated with tables and also forms that's why I am posting
it here.
Suppose I have to create 40 tables but their fields and field labels are
the same now it would be very difficult to create these for all the tables,
isn't there a way which can be used so that all the other tables take the
settings from one table.

I am having the same problem with the forms also.

 

[Jeff Boyce]

Let me state again, in a well-normalized relational database, you would NOT
want to be creating 40 identical tables (and their forms).

This is how you would handle it if you were using a spreadsheet, but Access
is not a spreadsheet.

If you'll provide more specific information about the DATA you wish to store
in these tables, the readers here may be able to offer more specific
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP