multiple table setup

[bond10aa13]

Hi I am new to access. I would like to set up individual tables for each group name i have within a table. Is there a shortcut other than individually setting up new tables. I have a lot of group names.

Thanks for any help, it is greatly appreciated it!

[pbaldy]

It would almost certainly be a design mistake to have tables for each group. It would help to know what you're trying to accomplish, but generally you would have a single table that had each group's data in it, including a field to denote the group.

[bond10aa13]

It is for a health insurance company. Within each group I have multiple individual info. In the main table with all the groups listed is the groups renewal and admin contact. Each group will have a different number of individuals hence I think it would be better to have a separate table for each.

[bond10aa13]

"who is john galt?" love this quote by the way! huge fan of the fountainhead and atlas shrugged!

[pbaldy]

Well, it's your database, but I'd highly recommend reviewing what's called "normalization" before going too far. What you're describing is great for spreadsheets, virtually always a mistake in a relational database. Designing for databases requires a different mindset than spreadsheets. I'm willing to bet money you'll regret it a week from now if you go down that road. Using forms will become problematic, as will reporting across groups. The number of people per group is irrelevant to the design, unless I'm missing something. You don't want to have to redesign the whole database when they add a new group. I have a lot of databases that handle data for multiple companies, and they all use a common table with a field for company. I'm rambling, so I'll stop. One link among many regarding normalization:

http://www.r937.com/Relational.html

I love those books too! I'm due for a re-read of Atlas Shrugged. I need for my wife to quit handing me books and saying "this one was really good". I can't get around to AS if I'm reading others.

[bond10aa13]

Thank you so much for the info and help. I think I was trying to make it more complex than it needed to be! Get on that re read there really might be nothing better!

[pbaldy]

Happy to help, and welcome to the site by the way. If you post more info about the data you're trying to store, I'm sure you'll some good ideas on the proper table structure (and you should do anything until you get the table structure right).