Sub Type

C

Christo Yssel

I have a customers table, but the customers can be a person or a company. I
do not want to use a multiple table, just a single table.

which will be best?

Table: Customers
CustomerID
CustomerType {C - company, P - person}
CustomerName
Initials
or
Table: Customers
CustomerID
CustomerType {C - company, P - person}
SurnameName
Initials
CompanyName

Will I be able to use the first option where you just leave initials blank
if it is a company or do I have to use the second option or is there another
better solution

Thanks
Christo
 
Top