Handling Different Kinds of Companies

[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

 

[Dorian]

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.

 

[Mike Sherrill]

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

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