I've gone round and round with the concept of Normalization. I've decided on a 125 field table. Most of the fields represent Periodic Table Elements - Mo Ni Mn Cr, etc. This is because we run samples, maybe 10 or more. A normalized database is
Lot Element Percentage
3555 Mo 5
3555 Ni 6
There was no good form design that made data entry easy to display and enter all 10 or so samples, so I went to a 125 field table instead of a 3 field table that made data entry a nightmare. The thing is we have 3 or 4 more tables that use the same 125 field format for the same reason. A part of me wants to use the additional identification fields in the table as different refernces for CHECK STANADARS, PRELIMS, FINALS, CID COMPOSITES, instead of having 4 or 5 individual 125 field tables for each. It does go against the logic, seperate different data to different tables, but one table with everything is appealing to me. What do you say?
Willie
Lot Element Percentage
3555 Mo 5
3555 Ni 6
There was no good form design that made data entry easy to display and enter all 10 or so samples, so I went to a 125 field table instead of a 3 field table that made data entry a nightmare. The thing is we have 3 or 4 more tables that use the same 125 field format for the same reason. A part of me wants to use the additional identification fields in the table as different refernces for CHECK STANADARS, PRELIMS, FINALS, CID COMPOSITES, instead of having 4 or 5 individual 125 field tables for each. It does go against the logic, seperate different data to different tables, but one table with everything is appealing to me. What do you say?
Willie