vba question from newbie

[pbaldy]

If there can only be pdf per record, I'd just have a field in the data table that pointed to the pdf file (a simple text field with the path). If there can be more than one pdf for a record, you need a linking table that had a record for each, with fields for the record ID and path.

[ninachopper]

I would prefer to have multiple pdf's, but I am a little confused. I set up a linking table with the two fields being the ID and the attatchment . Then linked them but only the title of the attatchment of the pdf is showing up on my reports, not a link to open the files up. Maybe because I'm a newbie, I'm a little unsure exactly you mean about "the path". Thanks so much for your time!

[pbaldy]

Personally I've never used an "attachment" field, where the attachment actually becomes a part of the db. I use a simple text field that contains the path to the attachment:

C:\FolderName\FileName.PDF
or
\\ServerName\FolderName\FileName.PDF

Then I use FollowHyperlink to open the file, via double click on the textbox or whatever.