I'm trying to create a DB to manage some accounts and budget data.
I have a form to insert records into a table (tblAccrual), but then I need to populate a second table (tblAccrualPaymentDates) with related data, only the number of records to add to the second table will be dependant on the 'frequency' field in the form.
For example, if the user selects 'Annual' (from a dropdown box), then I add one record to tblAccrualPaymentDates. If they select '6 monthly' then I add two records to tblAccrualPaymentDates. If they select 'quarterly' then I add four records and so on. Each of the lines I add to the second table would have a different payment date based on the frequency, i.e. the payment date in the first record of the 6 monthly one would be today and the second would be 6 months later, and the quarterly ones would be 3 monthly increments, etc.
Can anyone help me find the smartest way of doing this?