The simplest approach (not necessarily the best) is to define Body Weight, body fat and the calculations as seperate fields in the same record. That can be set up as a row arrange like this:
Body Weight | Body Fat | Lean Body Mass | Fat Mass
I would assume that the difficulty here is that you plan on multiple tests each with different data and calculations and you want to record different measurements all in the same table. Would that be the issue or does a single record as shown above work for you?
I was thinking about doing it that way but each test has a different formula for example. One that I would like to get is "One Rep Max" that would like this;
Bench Press Weight | Bench Press Reps | Bench One Rep max (formula; Weight/(1-(0.0278*Reps))
How do I account for different formulas? Can I have a field as the formula its self such as;
Field 1: Bench Press Reps | Value
Field 2: Bench Press Weight | Value
Field 3: Bench One Rep Max | Calculation; [Field 1] / (1-(0.0278 * [ Field 2] )
That's the direction in which I was heading.
I'd use two tables, Data, CalculationDetails
In the Data table of this record, define some fields: Field1Data (number), Field2Data etc. Define enough fields so that you can enter data for the most complicated calculation of those you will use for your tests. (you can easily add more field pairs after the fact if you need to.
Add a test name field you can populate with a dropdown list or pop up menu of tests.
In calculation details define a field: TestName of type text. Also add text fields for to serve as label fields for each of the data fields in the first table and each of the calculations to be performed with this data. In our first example, One such text field would store "Body Weight", another: "Body Fat" and a third: "Lean Body Mass".
Relate them by TestName. In your portal you can combine the Test name field with the data fields from your first name and the "label" fields from the second.
Now for the calculations: In CalculationDetails, add a text fields for calculations. In your first example, you have two calculations to be perfromed on the same set of data so you need at least two such fields. If other test do more calcs with the same data set, you'd need more.
Enter your calculation formulas into these text fields. For the Lean Body Mass calculation, you'd enter this text into a field named "Calc1Formula":
In your Data table, define a calculation field as Evaluate ( calculationdetails::Calc1Formula )
This way, you select at test by name, enter data into fields that automatically label themselves with the correct labels and your auto-labeled calculation fields then compute the needed results from the entered data.
Thanks I will give that a go as soon as I've had a full night of sleep... got a headache just reading that! Thanks again...