Creating duplicate records when loading from .DBO

[#1]

I want to be able to load records from a contracts database and create a record for each time an invoice will be generate over the next year.

e.g. Database as follows:

Contract Number Invoice Every (months) Last Invoiced

Contract 1 3 31/12/2009

Contract 2 6 31/10/2009

Contract 3 9 31/10/2009

New table should show for first contract, same principle for the second and third contracts

Contract 1 3 31/12/2009

Contract 1 3 31/03/2010

Contract 1 3 30/06/2010

Contract 1 3 30/09/2010

Contract 1 3 31/12/2010

I think the way to do it is to read each record line by line, decide if a new record is needed, if so create a duplicate and change the last invoice date.

I can not find a way to create a duplicate record. Can any one give me any tips on this.

Thank you

[#2 · Accepted solution]

Hi Adrian,

here are a quick shot.

Hope you are back on track now!

Good luck!!!

Rainer

[#3]

Thank you I will give it a try,