links to multiple files

[cjf]

I see how to create an OLE field, and insert it on a form
so I can link to a MS Word file. But when I try to add
more than one MS Word doc it overwrites the previous
entry. How do I link multiple MS Word docs to the same
Access record?

thanx

cjf

 

[DDM]

cjf, you need to create a separate table for the OLE field and link that
table to the original one in a one-to-many relationship. The primary key
field from the original table will be a foreign key in the table with the
OLE field. Then you can link any number of documents to a single record in
the original table -- just create one record in the OLE table for each
document you wish to add. Use the Form Wizard to create a one-to-many form.