I have a problem, in my head it works...but translating that into actually working....not so much! Here goes...

I created a form that our shipping/billing department uses, on this form is a number that is created using the day/month/year/24 time. Therefore when someone opens the form it would have a unique number ie 050220071548. Once they complete this form, it is to be sent to finance. The problem lies in that finance never knows if this form is coming, or if one has been completed.

Sooooo....I want to create a log sheet, so whenever the form is open and the unique number is created, a log sheet updates also showing this unique number plus a few other fields. I am trying to mistake proof this system. Let's just say the billers/shippers are a few pieces short of a truck load!

Any help would be great!