I have an estimating table that lists when bids are placed and accepted. I also have a summary report which shows how many bids were placed and how many were accepted on a monthly basis. The summary report is based off of the field [bid date] which is a formula date field that changes depending on whether the bid is accepted or not. It needs to change because if a bid was sent in January but accepted in February then the information for when the bid was accepted needs to reflect on the summary report for February. The issue is that I still need the information for when the bid was placed to reflect on the report for January. Is there a way to have the bid duplicate itself when it is accepted so that there is still a job with information when the bid was placed as well as a job with information as to when it was accepted? For instance, is there a formula that I can have for a checkbox that will duplicate the job when its checked?