Hi Steve:
>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...
Nope, they are not the same data type. There a char, varchar, tinyint, smallint, int, datetime and bit columns. Each piece of data represents finishing information. The finishing table record is 1-1 with each job record. Like I said, the data in this table is totally normalized. I can't see any sub-groups of data within the finishing record that could be broken out into child data/table(s).
-=Gary