Alistair,
No region with tiers, just individual fields, each for a different column
in the table the form serves. All fields are columns, none are variables.
You are right about RBase doing what you want even, as in my case, I don't
understand why. Maybe I shouldn't be questioning the results, but any
knowledge I gain will hopefully pay off again in the future.
Jim
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Alastair Burr
> Sent: Friday, July 27, 2001 6:39 AM
> To: [EMAIL PROTECTED]
> Subject: Re: RECALC Question
>
>
>
> Jim,
>
> If this is a form with a region and tiers then the calculation is
> only needed on
> the first row as this is duplicated through the rest of the region - but I
> didn't think it was possible to amend the second and subsequent rows.
>
> If they're straightforward variables on SEPARATE fields then I'm
> as lost as you!
> (But then R:Base always was good at doing what you wanted!!)
>
> Regards, Alastair.
>
>
>
>
>
>
> "J. Andrus" <[EMAIL PROTECTED]>@sonetmail.com on 27/07/2001 11:23:16
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by: [EMAIL PROTECTED]
>
>
> To: "RBase" <[EMAIL PROTECTED]>
> cc:
> Fax to:
> Subject: RECALC Question
>
>
> An existing data entry form has six columns of fields. Each
> column has five
> fields. All fields are table columns, none are variables.
>
> Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
>
> col11 col21 col31 col41 col51
> col61
> col12 col22 col32 col42 col52
> col62
> col13 col23 col33 col43 col53
> col63
> col14 col24 col34 col44 col54
> col64
> col15 col25 col35 col45 col55
> col65
>
> Data is entered into the first, second, fourth, and fifth column fields.
>
> The values in fields in columns three and six are calculated. The
> designer's intent was to show the absolute difference between the
> two fields
> to the left of columns three and six when VAR vtest = 1. Therefore, each
> field in columns three and six contains the appropriate variation of the
> following expression which would be in field col31.
>
> col31 = (IFEQ(.vtest,1,(abs(col11-col21)),(the not equal condition)))
>
> The data entry order is col11, col12, ....col15, col21, col22.....col25,
> col41, col42....col45, col51, col52....col55.
>
> As a value is entered in each field and the field is exited the
> intent is to
> have the result of the IFEQ expression show in the corresponding column
> three or column six field. For example, entering 8 in col11
> would result in
> 8 showing in col31 when exiting col11. Then if a 1 is entered in col21
> field col31 would change to 7 as col21 field is exited.
>
> We can make this happen simply by doing a RECALC entry procedure on entry
> into col31. Putting the RECALC in field col31 (and ONLY col31) causes the
> desired result to show in ALL of the rest of column three and column six
> fields as values are entered into corresponding column one and two fields
> and columns four and five fields.
>
> If anyone can understand what I am trying to describe here can you explain
> what is happening? Why does one RECALC in col31 provide the
> desired results
> in all other column three and six fields as data is entered in
> columns one,
> three, four, and five fields?
>
> TIA
> Jim
>
>
>
>
