FMP9 Time Billing database

Please help me. Hello I am trying to make the field Yearto date add
the total when the form is filled out to add the weeks earnings for
every new record when Name is different.Is this possible? When I ,ake
new record for Bobby the Year to date is carried from the previous
record and then add the total when the new record is filled out and so
on and so on But when New record is created Name changes the year to
date is associated with that name. I dont know if I am explaining this
right. Any help would be appreciated. Thank you.

Re: FMP9 Time Billing database

Scott wrote:
> Please help me. Hello I am trying to make the field Yearto date add
> the total when the form is filled out to add the weeks earnings for
> every new record when Name is different.Is this possible? When I ,ake
> new record for Bobby the Year to date is carried from the previous
> record and then add the total when the new record is filled out and so
> on and so on But when New record is created Name changes the year to
> date is associated with that name. I dont know if I am explaining this
> right. Any help would be appreciated. Thank you.

create a number field Year, that is an auto enter calc, and define it to
parse the year from the current date:
Year(Get ( CurrentDate ))

create a rel Year::Year
field Amt (earnings)
create a calc field, number result, unstored, to sum the related Amt field

this will update with a refresh, commit script step or layout change


If you also want a running total for each individulal (P_ID), create an
additional rel from P_ID to P_ID, and a similar sum calc

Re: FMP9 Time Billing database

Thanks Chris I really do appreciate your help..But that ia all to much
for me I just dont understand it..I guess Ill go back to reading more
on it. I really wish I could do this.. Scott.
On Sat, 19 Jan 2008 08:58:43 +1030, Chris Brown
wrote:
c
>Scott wrote:
>> Please help me. Hello I am trying to make the field Yearto date add
>> the total when the form is filled out to add the weeks earnings for
>> every new record when Name is different.Is this possible? When I ,ake
>> new record for Bobby the Year to date is carried from the previous
>> record and then add the total when the new record is filled out and so
>> on and so on But when New record is created Name changes the year to
>> date is associated with that name. I dont know if I am explaining this
>> right. Any help would be appreciated. Thank you.
>
>create a number field Year, that is an auto enter calc, and define it to
>parse the year from the current date:
>Year(Get ( CurrentDate ))
>
>create a rel Year::Year
>field Amt (earnings)
>create a calc field, number result, unstored, to sum the related Amt field
>
>this will update with a refresh, commit script step or layout change
>
>
>If you also want a running total for each individulal (P_ID), create an
>additional rel from P_ID to P_ID, and a similar sum calc