What you think about...

  • Thread starter Thread starter Dragan
  • Start date Start date
D

Dragan

Customers may be physical and company persons. They have different data.

How to make the table Customers? Together or separately (one table or two
tables)?

Thanks
 
Think about how you'll use the customers data. Will you be differentiating
between people and companies when you need to do something, such as
selecting a customer for an order, or generating an invoice or statement, or
such?
 
Dragan said:
Customers may be physical and company persons. They have different data.

How to make the table Customers? Together or separately (one table or two
tables)?
Click to expand...

Yes <g>.

You need to look deeper. A corporate customer may have a person as a
contact with a different address, a person customer may have different
addresses for delivery and invoicing, etc. You may be able to design a
generic table for both types but you may prefer to have different
separate tables for Individuals, Companies (with a column for an
associated Individual e.g. a contact) and Customers (columns for
associated Individual and/or Company entities). It all depends on the
data you are capturing and what you plan to do with it, details of
which you have not posted.

Jamie.

--
 
Back
Top