UnitsToElement

[Murray Carter]

I am doing a Water Analysis DB
Structured
Fields
Ca
Mg
Mn
BOD5
PH
etc.
Would like to do a table where the fields of above becomes records ie
Element Unit
Ca g/l
Mg g/l
Mn g/l
BOD5 mg/l
PH -H
etc.
Then have a function that would return the unit from field name
Hope this is clear
thanks
Murray Carter

[pietlinden]

WaterAnalysisResults(
AnalysisID - Long Integer,
ChemicalID - string/long integer (depends on what makes sense)
Measurement - Number of some type
....)

Then you could have a table of Elements (well, loosely speaking,
anyway)

(Element, Unit)
and then you could just link that table to your measurements table and
you'd be all set. But then you MUST be consistent with the units of
measurement.
Then returning the measurement is a simple matter of using a join in a
query... nothing to it.