Address Tables - Multiple Addresses in Microsoft Access, Part 5


	Back to Multiple Addresses 5 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Address Tables

Dirk Merkel

2 years ago

Great mini series! Came at the right time for me. Thank you.
I also got a question. A future DB of mine will have several groups of people/organizations. (e.g. customers; local authorities) And all of them will have multiple addresses. Each group will have their own table.
Is it wise to have just one address table for everybody or should i run several address tables based on the groups I've mentioned.
From a technical point of view I'm sure both ways are possible but having the lack of experience on my end, I would like a second (or third) opinion on this.
Regards Dirk

	Sami Shamma @Reply 2 years ago
multiple tables are a bad idea 99.99% of the time.

	Richard Rost @Reply 2 years ago
Don't put each group in their own table. Have a GroupT table that lists your groups and then each person can have a GroupID this is proper relational database design. Or if a person can be in multiple groups, use a many to many relationship and a junction table. Relationships Many-to-Many Too Many Tables

	Richard Rost @Reply 2 years ago
Groups

	Dirk Merkel OP @Reply 2 years ago
Thank you guys. More studying to do.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Multiple Addresses 5.

Next Unseen

New Feature: Comment Live View