Want to link to a network directory...

[marydoyle9]

I have a database that contains change requests from users. Each change has an associated design document on our network (MS Word docs all in same directory). I want to be able to somehow link each change request with the associated document. Maybe by using a dropdown and showing the list of files in the directory (user would select matching file). All the design documents start with CR and are immediately followed with the Change Request number. I was able to somehow do what I wanted at one point because I remember having to have the CR and the number altogether in the doc title but I lost my notes (they are probably with my mind...). Can anyone give me some help on this? Please keep it simple... because I am... Thanks! Mary

 

[Oldsoftboss]

This example attaches an xl spread sheet but may help
Dave