i want to set up a table that will hold a payment plan information. basically:
start date: 06/01/06 (global)
original amount: $300.00 (global)
payment day of month: 15
Amount of Payment: $100.00
i would like to know if there is a way that i use a loop to populate the records for an id no. by putting in the information and having it go through and set up the payment plan until it hits the original amount?