Hello Gary,

Do these "finishing options" fields all have the same dataType? Can you provide a little more detail on what is in these fields? I'm wondering if there could be a related child-table that could hold this information...

>I have a table that basically contains "finishing" options. These are various values that dictate how a job should be finished. The table is completely normalized. However, for any given job, there may only be a few finishing options selected, on average between 4 and 6 columns. The finishing table has about 70 columns. So for each finishing record, the majority of the columns are "empty".
>
>I have looked at whether I could create a number of smaller tables that contain more logically grouped finishing options but each finishing options is generally individual and one-off. So, I could end up having to manage many small tables with no logical grouping of columns. Therefore, the current table design seems to be the obvious choice.
>