>Granted, you want to normalize but I'm curious as to what you consider excessive when creating a table (i.e. fields). Also, with tables of many fields, isn't the process of creating data entry forms tedious?
>
>Curious to know the habits and possible similarities of others
>
>Thanks,
>
>Vernon
I think my biggest table in this sense, in the system mostly designed by me, for Bata-Bolivia, is the article table, which has information about finished products, raw material, and intermediate articles (products produced, that are not the end-products). Even different types of leather, which is a separate category. Since each of these types of "articles" has its own requirements, there are several fields that are only appropriate for one or the other. Also, there are certain fields that are not precisely normalized, and even obsolete fields that are no longer used.
This table has 66 fields.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)