Scanning Document

[Verda]

How do you scan a document e.g a photo or a word document which is unique to one patient for example and save this in the database?

for example for each patient i want to scan in a hand filled document of their 7 day diary. this document is only unique to them and i want to save this in their records.

any advice would be appreciated. thanks a lot guys.

 

[stopher]

The key point is that scanned documents would be saved as picture files (JPG etc) in your chosen directory. They do not get saved in your database. Instead you store the link to the file/path.

If you only ever have one file (scanned document) per patient then you could store the link in the patient table. However, more likely you have many files, maybe of different type. In which case you can create a new table which lists all links for each PatientID. This would then be a one-to-many relationship to the Patient table.

As for displaying the scanned picture, probably the easiest way is to make the link field a hyperlink so that when it is clicked on, the file is opened in your favourite picture viewing software.

If you want to see the picture in the form then you need to write some code to display the picture in the form. Search these forums for storing and displaying pictures as it's been covered many times. Also take a look at this example from Oldsoftboss.

Chris