I have a form that I am trying to reproduce in VFP 3.0. This form contains parent fields and a grid populated with related child records. The related child records have the following structure:
claimPeriod
totalMeals
category
rate
claimAmount
THere are 3 categories for each claimPeriod( free, reduced, paid). Each ADD to the tableinserts 3 records, one for each category. All of this works fine. However, There is a netAmount textbox on the form that needs to totalthe 3 claimAmounts for each claimPeriod. This textbox needs to be updated whenever the grid is scrolled so that it shows the appropriate netAmount for the group of 3 categories associated with the claim period. The grid on the form shows 4 claimPeriods(totalling 12 records-3 for each claimperiod) with a textbox for a netAmount for each of the 4 claimperiods. I cannot come up with a way to do this. Any suggestions would be greatly appreciated.
--Shane