A
angie
i have a table to enter payments with payment field, amount, date field,
status field and frequency field. depending on the payment i have to repeat
the entry every month, three months or year. i would like to avoid that. for
example i would like to enter a payment and only when the status field is
updated to "completed" i would like to have an automatic entry for the next
deadline. e.g. payment=telephone,amount=5 euro,
deadline=8/12/07,status=completed,frequency=1 month. i would like to have an
automatic entry (because the payment has been completed) with deadline
08/01/2007.
is it possible to accomplish that?
status field and frequency field. depending on the payment i have to repeat
the entry every month, three months or year. i would like to avoid that. for
example i would like to enter a payment and only when the status field is
updated to "completed" i would like to have an automatic entry for the next
deadline. e.g. payment=telephone,amount=5 euro,
deadline=8/12/07,status=completed,frequency=1 month. i would like to have an
automatic entry (because the payment has been completed) with deadline
08/01/2007.
is it possible to accomplish that?