>
>
For a specific project I had a grid something like this :
>Depth
>totalSO4
>dissolvedO
>NH3
>NH4
>pH
>Temperature
>Salinity
>...
>
>Users were entering/updating data and their data was being validated against possible ranges. Well ranges cannot quite prevent erronous data. Say they could enter these w/o breaking range (Salinity might be in range 44-75 : just imaginery, scientist do know them not me :)
>
(meters)
>Depth Salinity
>----- --------
>0 44
>1 44.1
>2 44
>3 70 ---> Ooops. It shouldn't change this far.
>4 46
I couldn't find a good and fast way to check these online. So my workaround was to show a line graph against depth per parameter below the grid. While the data is in allowable range users could see it makes a "peak" as soon as they enter a value like above. Or a viewer-checker could better say data is erronous at a glance w/o checking the data one by one (even I caught their erronous data w/o an idea about the ranges:)
>What I did was to create a specific line graph container class. For each subclass dropped on form I only changed properties "Label" (tSO4, NH3...) and fieldname that graph is drawn for (and a few optional like line color, mark color..). Class was SQL selecting depth and values for the field, sizing them, and drawing lines for the values.
>When I have more time I'll try to send you the class with sample.
>Cetin
This is exactly the type of thing that I'm doing. In my case its Pressure against temperature - as pressure increases, the maximum allowable temperature should decreases. Each set of figures produces an arch which can be clearly seen with a graph.
I would be most grateful if you could dig out the class. It would save me so much time (and embarrassment if I get it wrong).
Jason