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
