invoice dublication with auto date update

[alexcross2005]

hi. Please help me !!!!

how do I dublicate an invoice and have the date update automatically to the same day the following month? I am trying to have a re-occuring invoice system and want to dublicate invoices for the next six months. I have an Invoice table and an Invoice Line Items table related by InvoiceID.

Edited October 12, 2010 by Guest

[bcooney]

Hello, Alex, welcome to the forums.

You would need to write a script that duplicates the invoice record and all its line items (with a new Invoice ID), then sets the date to the original invoice's date, incrementing the month. However, if you want the "second Friday" of the month each time, that's a bit more complicated.

However, this is an odd request to me. Can you elaborate on this requirement?

Also, it would be helpful to know what tables you have and how they are related. Do you have an Invoice table and an Invoice Line Items table related by InvoiceID?