In addition to what LJ says, I think you might want a char field on the child form to hold the filename of the jpg (put a filter on the child form to update it on submit & modify). Then you can use the char field in the table field on the parent form so they can see the filename.
Also, if you put the display only attachment pool on a hidden tab, make sure the user has permissions to the tab as well as the pool (or put the pool somewhere else). I think this is a registered bug, but I don't have the number handy. This bug was for a 6.3 server, I haven't tested on 7.x. Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach LJ Longwing <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 05/15/2008 12:07 PM Please respond to [email protected] To [email protected] cc Subject Re: How to open an attachment in a child form record from a tablefield on the parent record? ** 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: [email protected] 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___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
