D
Derek
I need to make a table to store multiple measurements on parts and I need
some ideas how to proceed.
Each measurement job consists of up to 289 measurements; the property being
measured is identical for all locations, e.g. thickness, but the part is
measured in 289 different locations. Cartesian or polar coordinates are used
to define the locations of each measurement on the part.
So, in the case of a 289-point measurement, for each record I will have 289
measurement values. For each measurement value there will be EITHER one
x-coordinate and one y-coordinate OR one radius and one angle.
What should my table look like and what is my primary key? I have a
gut-feeling that the answer is obvious, so I'm sure I will get a useable
answer from someone. Thank you.
some ideas how to proceed.
Each measurement job consists of up to 289 measurements; the property being
measured is identical for all locations, e.g. thickness, but the part is
measured in 289 different locations. Cartesian or polar coordinates are used
to define the locations of each measurement on the part.
So, in the case of a 289-point measurement, for each record I will have 289
measurement values. For each measurement value there will be EITHER one
x-coordinate and one y-coordinate OR one radius and one angle.
What should my table look like and what is my primary key? I have a
gut-feeling that the answer is obvious, so I'm sure I will get a useable
answer from someone. Thank you.