>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
Hi Vernon,
The limit is 255 (or 254) fields per table if I recall correctly.
The practical limit varies. I think I never had more than 70 fields in a table.
If it's not broken, fix it until it is.
My Blog