I can?t seem to wrap my head around this one today, but I?m pretty sure it can be done.
I need to add a URL button. This button will:
Change the Billing Status field to Complete
Add new record to the same table. Two fields in the new record need to auto populate as follows:
Billing Start Date field populates to the day after the Billing End Date field from the previous record.
Billing End Date field populates to 30 days in the future from the Billing Start Date
This button will be placed in a table report for quick manager approval.