Hi all;

Sorry if this is noob question.

I have the following files/data;

Shoots
-----------
shoots# relationship link
member# relationship link to members record - firstname, surname
hand# relationship link to handicaps record - current handicap
match# relationship link to matches - match type
date
score number
old handicap

ie
David Goble, rapid fire, 31011998, 456, 0
David Goble, rapid fire, 31121999, 451, 0
David Goble, rapid fire, 31012000, 446, 0
....
David Goble, rapid fire, 310122000, 456, 149
David Goble, rapid fire, 310122000, 556, 149
David Goble, rapid fire, 310122000, 446, 140
David Goble, rapid fire, 310122000, 451, 140
David Goble, rapid fire, 310122000, 556, 140
David Goble, rapid fire, 310122000, 459, 054


Handicaps
-----------------
hand# relationship link to shoots -

numtotext(member#)+"-"+numtotext(Match#)
member# relationship link to members record - firstname, surname
match# relationship link to matches - match type
date
resets
initial handicap
current handicap

ie

inital handicap = matchmax - average (456 + 451 + 446)
= 600 - 451
= 149

ch = current handicap
oh = old handicap

if (oh + score > matchmax)
then
ch = oh - ((oh + score) - matchmax)
= 149 - (( 149 + 556) - 600)
= 149 - ( 705 - 600)
=149 - 05
=140
else
ch = oh

David Goble, rapid fire, 31121998, 0, 149, 149
David Goble, rapid fire, 31121998, 0, 149, 140
....
David Goble, rapid fire, 31121998, 0, 149, 054

My problem is I am not sure how to implement this... I really need
some advise... thanks