Im starting to design some software/system for work even though its not in my job description, and learned a little of it at college so thought id speed the process up rather than waiting for the IT monkeys downstairs to get their act together.
I will be including a database which needs to be written into by forms and info displayed.
I have a small question too
Is it possible for me to have a field in my table that links to one record, and has either the file path of one or multiple files to it or be actually attached.
If so then would i be able to pull up the data from the database, then launch the actual file via the program, view it withinin the program, or view it with the external sofware that relates to the type of file (likely to be pdf)
Basically im wanting to scan loads of files, and depending if i can get one file or one section scanned into one pdf file, or if i have to save them as seaparate pages determines this. These are gonna then be linked into the database where i will create records for each.
Im trying to speed up Paperless office in a way, even though i have problems with the scanner and the way it can save the scans, but thought id at least start designing a reasonable system