Linking Records to their Associated PDF Files

[Dar]

I work for an engineering firm and I have a table in my
Access 2002 database that holds data regarding
engineering drawings (i.e, drawing #, drawing size,
project #, etc.).

I have a .PDF file for each drawing and these .PDF files
are located on one of the servers at work. Each record in
my table (each drawing) has an associated .PDF fle, or
each record could have more than one .PDF file associated
with it.

I need to link each record in my table (each drawing) to
its .PDF file, which is on a server. I've added a 'text'
column to my table and I also have the full path to where
the actual .PDF files are.

I need help on how I can get the .PDF file name for each
record and insert it into my table.


Can anyone please help????


Thanks in advance.