Advice on table relationships

[John]

I have a database in two halves. the tables on one side hold transaction
details and the tables on the other side hold address, phone number and
email. The two tables in the middle hold entities "Companies" and "People".

Any of the Companies or any of the people can be suppliers or customers.

Three tables from the transaction side (tblJobCard, tblGoodsIn, and
tblPayments) need to relate to the entity (ie company or person) that is
buying or supplying or paying.

Each Company and person needs a relationship to address, phone and email.

Any suggestions for the correct way to do this, one big junction table?

John

 

[Geof Wyght]

John,
Here's a start. A company may have an address, but it
shouldn't have a phone number nor an e-mail address. When
you dial a phone number, a person answers, not a company.
So you can have a company-address table. Make a company-
person cross-reference table. Make a person/phone/e-mail
table.
Geof

-----Original Message-----
I have a database in two halves. the tables on one side hold transaction
details and the tables on the other side hold address, phone number and
email. The two tables in the middle hold

entities "Companies" and "People".

 

[John]

I can't say I agree. All companies have a general switchboard phone number.
If it's a company that I don't deal with very often I might not have a
contact name, so I need to link company-phone. If I do have a contact then I
need person-phone-company. I also do business with indivuduals, so there
won't be a company involved.

John

 

[Geof Wyght]

John,
You're right - good point.
Geof.

-----Original Message-----
I can't say I agree. All companies have a general switchboard phone number.
If it's a company that I don't deal with very often I might not have a
contact name, so I need to link company-phone. If I do have a contact then I
need person-phone-company. I also do business with indivuduals, so there
won't be a company involved.

John





.