Scanning documents linking to access record

[nyrob609]

Question,

I created a database that holds information on authorizations we obtain.

What I would like to do is scan any paper works related to that specific record and create a link to the folder where I am holding the scanned document. I also would like for the person working the case to scan the documents by choosing the category, naming the file and hit a command button that opens the scanner.

I would have a form that filters by ID# and it will give me a list of all documents scan for this record (i.e. see below) and I will click the file name and the document will open.

ID # xxxx

Scan document type File Name
Insurance Card IDNoXXXXInsCard
Authorization Form IDNoXXXXAuthForm

Any ideas where I could find information on how to do this???

Thank you inadvance for your assistance.

 

[HiTechCoach]

I have an example that I use to attach scanned docs

see

http://hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=14&Itemid=28

 

[nyrob609]

Thank you, this might work. I am going to incorporate the table but i am confuse about the other two table the index and related table.

 

[nyrob609]

Thank you again, this works great.