Re-evaluate field rules

[Edward F. Schulz]

Hi Phorum,

I am developing an app that shows the winners in a golf skin game. The app has a host of table level calc (N) fields. Three(3) of them are involved in my problem. The first field adds the adjusted values of the first 9 holes, the second adds the adjusted values of the last 9 holes. The third adds these 2 calc fields for the adjusted 18 hole score. The first 2 holes (calc fields)work ok. The last which adds them together displays a peculiar value until I go into field rules and re-evaluate. Am I doing something wrong, or do I need to put some code to make them re-evaluate? I am definitely saving the input data (F9) before displaying the browse to read the results.

Thanks you for any and all input,
efs

[Stan Mathews]

RE: Re-evaluate field rules

Don't know why, but try changing your third field to add all 18 together instead of the two parts.

[Tom Cone Jr]

RE: Re-evaluate field rules

Ed,

Sounds like you're building a

Calc (18 hole adjusted score)

on a

Calc (pair of 9 hole adjusted scores)

on a

Calc (sum of 9 adjusted scores)

on a

Calc (raw score per hole, adjusted for handicap)


You might get better results if your structure includes

18 fields with the per hole adjustments preloaded (this would be the handicap per hole)

21 fields for the raw scores, nine hole subtotals, 18 hole grand total

21 fields for the adjusted scores

-- tom

[Edward F. Schulz]

RE: Re-evaluate field rules

Thanks for the input guys. My table includes 18 fields for the gross score on each hole, 3 more calc fields to total front 9 gross total, back 9 gross total and these totals added together for the 18 gross total. Next there are 18 fields that show where the HCP strokes fall (this would be different for each course), there is also 1 field that holds the players handicap. Next there are 18 calc fields that adjust the net on each hole as a function of the HCP and on which holes the strokes fall. Obviously there are calc fields for the net adjusted totals as well. The only place that this rears it's ugly head is when I add the adjusted front side total to the adjusted back side total (adj_fr_tot=adj_bk_tot). All else is working well including the colors in the browse that varies between double bogies and double eagles.

Thank you for reading,
efs

[Edward F. Schulz]

RE: Re-evaluate field rules

Hi Tom,

I pretty much have what you describe, see my other reply.
efs

[Tom Cone Jr]

RE: Re-evaluate field rules

Ed,

If you added 21 fields for the net score on each hole, each side, and total there would be less processing required at one time. Instead of having to adjust (gross to net) and then sum, the adjustments would be done one hole at a time. The 9 and 18 hole totals would be simple sums.

-- tom