1.) I need a unique random number generator that generates a unique 4 digit number inside of a procedure I currently have.
2.) I need to use this unique number to be the name of the file that gets sent to the ftp server
3.) I need this number printed on a specific receipt using quick reports
4.) This unique number needs to be written to the record in the database(access)
***I already have the code in place to create this file, and to send it to the ftp server*** what i need is for you to implement the random number generator and change the file name to the unique number, and write the unique number to the database.
All work must be done on my machine using teamviewer.