Rabu, 12 Februari 2014

[MS_AccessPros] One table or many?

 

I have a database that tracks insurance policies for companies.

 

I have separate tables for Health insurance , life insurance, Disabilty …etc.

 

Most policies have different items that need to be tracked so the tables look different, with the exception of about 6 fields.  All policies have about 6 or so thing in common.

 

Should I combine all this info into one table or should I keep the tables separate.  The table would become rather large in my mind (35 fields) but I would only have one table.

 

What is the best way to  do this.

 

Thanks for the comments.

 

Bill

MN

Balmy 18 degrees

 

 

 

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
.

__,_._,___

Tidak ada komentar:

Posting Komentar