Author: ClarkNK | Posted on: 8/28/2008 9:02:16 AM | Views : 311

Not sure if this is the right place to ask this, but here goes anyway.

I have a relational db with an Items table, and a Values table where the user can enter, using a FormView, Values versus date for any selected item.

In simple form, the  Values table would look like this:

Date       Value     Item_ID

and so if the Item_ID happened to correspond to the Item named Weight, the user enters as the Value, the Weight at different dates. 

But -- some Items have more than one Value associated with them, like Blood Pressure for example. In such a case my Values table would be set up like so:

Date      Value1     Value2      Item_ID

and the user could use put his Diastolic reading in the Value1 position, and the Systolic reading in Value2 position.

THE QUESTION: Different users will w ...

Go to the complete details ...