Really quite simple once you think about it....you already have the attachment form with its attachment pool and field, you already have the table field on your main form showing you all of the records, that's 90% of the way. Now you need an attachment pool on your main form, and a display only attachment field. Disable table drill down on the table field, create an AL that fires on dbl click of the table row that does a setfield from the attachment form to your main form into the display only attachment field. Then have a second AL that fires on dbl click that opens the attachment from the main form. This will give them the ability to open the attachments stored in your attachment form. Let me know if you get stuck on anything I have said...I've implemented this a number of times with great success.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Thursday, May 15, 2008 12:38 PM To: arslist@ARSLIST.ORG Subject: How to open an attachment in a child form record from a tablefield on the parent record? ** Hi everyone, We have a need to store many .jpg files that we will periodically access. We want to access them from our Site form but to store them on this form would probably not be efficient. There will be approximately 10 .jpg files per Site so I thought a child form would be a better storage area. Initially my thought was to simply use a table field on the Site form displaying the necessary fields from the child form. On the child form there would be an attachment pool. There would be only one attachment per child record because other identifying information goes with each .jpg file. So in the table field we'd see the attachment file, description name, and view name for each child record associated with that Site. Ten child records, ten rows on the table field, ten .jpgs. Problem is, you cannot select the attachment field (filename) in the table field. Yes, we can double click on the row and access the .jpg file directly on the child record but of course that is not what they would prefer. They want to see the .jpg filenames, double click on them and whalaa they are open directly from the Site record. I thought it sounded reasonable until I'm playing around with the concept right now. I've looked through the documentation for some way to display this other than a table field and if it's there I'm missing it. Any suggestions on how I can accomplish this? ARS v7.0.1P3 (server, admin, user) Oracle 10g Windows 2003 I appreciate your help and ideas. Let me know what other information I could provide. Thanks, Susan Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 312-529-5325 [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"