Have you thought of making a 1-M relationship between the general test info and the 'things checked'? The detail table could be identified with a type field to show what test result it is.
If you do this, adding a new 'type' does not require any changes to data structure.
>Gregory,
>
>Thanks.
>
>It is for laboratory analysis on meterial. Lots of things to check.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
