I have four to five hundred records in a very simple database (One Form and One View).
Every single record has a serial no. as part of the record. Ther serial number is in the format 73147238 with the TYPE set as Number. The type can be changed if necessary.
I also have a CD with four to five hundred subdirectories, each subdirectory name relates to serial number. I.e. A record in Notes has the serial no. 73147238 and their is a directory called D:\73147238
This directory contains two small files Prima.lib and Serialid.1 with a combined size of 440 Bytes. Their are only the two files in the directory and nothing else.
I need an Agent\Script etc. which will look at the Serial No. of the record and attach the corresponding files from the subdirectory.
This is only a one off thing and I'll have the database on my local machine and the CD in my local machine.
Hope thats enough info, look forward to some suggestions about how best to go about this, I have zero LotusScript skills and a reasonable amount of Notes Database writing skills.