This is kind of a general question where there is really no clear answer. Just looking for opinions... Here goes.

I have a complaint table with lots of fields. Certain fields are only used with a certain type of complaint. Would it make sense to seperate the large complaint table into 3 sub-tables that hold the fields unique to that type of complaint? This would mean that I would have to use a query to combine the data.

Any opinions that you may have will be helpful.

thanks.

tim