I will have to do this process in EXCEL first before it is made into a database. I will have many files, but there is about 7 - 9 files that work all together as one e.g.
X192AD1-test.docx X192AD1-test.avi X192AD1-test.mpg X192AD1-test-small.jpg X192AD1-test-preview.jpg X192AD1-test-pdf
All the above works as ONE file.
I do not want to use a numbering system, e.g. 00001, 00002, 00003 because people can determine the age of the files, 00001 is older than 000032.
Can anyone give me some advice regarding this because of course I cannot repeat the primary key and I am not sure how to approach this.