Hello, I created a very simple A

[dalex17]

Hello,

I created a very simple Access 'Log" database. The objective is to log all calls that are placed to our software developers on an Access Form.

FYI - Each log issue has a unique log number.

I would like to learn how I can link backup documents to each issue. For example, if issue # 1212 involves a print screen of an error message in Microsoft Word, I would like to learn of a way I can link that record's issue to that Word document, so that I may view it at will when looking over the details of the issue on my log form in the future.

I hope this makes sense but please let me know if I can clarify.

Thanks,
Dalex

 

[PaulF]

you can use a Hyperlink field in the table, that way all you have to do is click on it and it should open (if the data is correct, and you have the file type associated with a program such as .doc with Word).

PaulF

 

[GingerR]

to expand on PaulF's idea: in your log table, create a field called DetailPath or whatever you want. make it's data type be HYPERLINK. then in that field, you will always input the path to the related document. if you are working on a server, perhaps you will create a folder if your group doesn't already have one. then your path will always be

\\servername\sharename\LogDetails\CustomerProblem.doc

do not use drive letters like H:\ because others using the database may not have their drives set up like you do.

also--think about this: could there be more than one document per log number? if so, instead of putting the hyperlink field into your main log table, you'd create a SECOND table called i.e. LogDocuments, with fields LogID and LogDetailPath. make this second table into a SUBFORM in your main Log data entry form. the master/child relationships will be LogID. then you can enter ONE OR MORE supporting documents to each LogID.

hope this helps. you can look up examples in HELP and many text books.