Please help
I am using Access 2007 and have a table to store PDF file certificates (tblPDF) with 4 field names
pdfID (PK) AutoNumber
CertNumber (Number) indexed no duplicates
PDF (Attachment)
GaugeID (Number)
GaugeID is the FK in the tblPDF table.
The PDF certificates have unique certificate numbers.
I have an equipment table (tblEquipment) with a field called "SerialNumber"
What i am trying to achieve is this, when i double click on the serial number i want access to display the certificate in PDF format.
Any help or other ideas would be greatly appreciated
I am using Access 2007 and have a table to store PDF file certificates (tblPDF) with 4 field names
pdfID (PK) AutoNumber
CertNumber (Number) indexed no duplicates
PDF (Attachment)
GaugeID (Number)
GaugeID is the FK in the tblPDF table.
The PDF certificates have unique certificate numbers.
I have an equipment table (tblEquipment) with a field called "SerialNumber"
What i am trying to achieve is this, when i double click on the serial number i want access to display the certificate in PDF format.
Any help or other ideas would be greatly appreciated