I have 3 tables: Parent, Calc and Equations, P, C, E.
E contains a text field (eventually >1) where each record has a different equations.
C is related to E [ C::_fkE > E::__pk ] and a calc field = evaluate(E::field1).
P is related to C [ P::__ID < C::_fkP ].
1. I have considered using C to simply calculate E equations based on whatever is the current P record, ie. no permanently stored Calc records because the data would be pulled up by whatever P record is current. Bad idea?
2. To update Calc::_fkP I have tried using a calc field [ = P::__ID ] or a number field set by a script:
Go to Layout [ “Calc” (Calc) ]
Go to Record/Request/Page [ First ]
Set Field [ Calc::_fkP; P::__ID ]
Go to Record/Request/Page [ Calc::__ID + 1 ]
Exit Loop If [ Calc::__ID= 50 ]
Commit Records/Requests [ No dialog ]
Neither resets the Calc::_fkP record number. How might I do this?
3. Evaluations: These appear to calculate correctly. However, if I update fields used within the calculations, the calc only updates if I click directly into the Calc layout cell in which the evaluation is done. How do I automatically update these evaluations?