Please help
I am using Access 2007 and have a table to store PDF file certificates in (tblPDF) with 4 field names
1. pdfID (PK)
2. PDF (Attachment)
3. CertNumber (Number) indexed no duplicates
4. GaugeID (Number) (FK) from tblEquipment

The PDF certificates have unique certificate numbers.
I have an equipment table (tblEquipment) with a field called "SerialNumber" (Text) indexed no duplicates.
What i am trying to achieve is this, when i double click on the "SerialNumber" i want access to display the certificate relative to the serial number in PDF format.
Is this possible or am i going about it the wrong way?
Any help will be greatly appreciated

Hi Peter

Oops my mistake, i have a form with a subform based on a table (tblEquipment)

The "CertNumber" is the common field as this is indexed and no duplicates allowed.

The Serial number is the object i would like to double click to view the PDF certificate

example

[Serial Number] [Description] [Certificate Number]

[TW01] [Torque Wrench] [12345] <---------- certificate number in PDF table, this is the certificate for equipment TW01
TW02 [Torque Wrench] [12346] <---------- certificate number in PDF table, this is the certificate for equipment TW02

and so on

I hope this helps