Repeating Fields Calculations

[pradeep]

I have 4 repeating fields L$,D%,D$,S$

L$ is available all the time.

If D% is entered D$ & S$ should be set with a calucation involving L$ & D%

Or

If D$ is entered D% & S$ should be set with a calucation involving L$ & D$

Or

If S$ is entered D% & D$ should be set with a calucation involving L$ & S$

No Button can be used to trigger a script.

Please reply to [email protected]

[LiveOak]

I love trick questions. The problem here is that a field can either be an entry field or a calculation, not both. You can solve the problem by having an extra entry field for each value that MAY be entered. On your layout stack each entry field behind the corresponding opaque calculation field. Set the calculation field to prohibit entry (I know you can't anyway, but this will cause the rear field to be selected when you click on the front field).

I leave the working out of calculations to the user, but this is the general technique.

-bd