Handling Different Kinds of Companies

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

Suppliers, clients, consultants -- do most of you handle
all of these in a single tblCompanies table, or separate
them?

In our company's case, a single company might be all three.


Kevin Sprinkel
Becker & Frondorf
 
You need a Company table, a Relationship and a CompanyRelationship table
So you will have
Company contains
A and B etc
Relationship contains
Supplier and Client etc
CompanyRelationship contain
A Supplie
B Clien
B Supplie

Of course it depends on what you are going to do with these tables and what attributes they have.
 
Suppliers, clients, consultants -- do most of you handle
all of these in a single tblCompanies table, or separate
them?
Click to expand...

Start with "parties", a supertype of the two subtypes "persons" and
"organizations".
 
Back
Top