Thanks for all the help and suggestions. I built a separate form and a button to call it from the parent form. The button pushes the request ID to the attachment form on open and a table on the parent form only shows attachments related to that entry.
Thanks again! -Matt Matthew C. Gayford Technology Research & Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug Sent: Friday, January 25, 2008 11:48 AM To: arslist@ARSLIST.ORG Subject: Re: Lots of Attachments ** I am a big believer in having a table field on my form that references another form that holds the attachment. As then 1. I can have an unlimited number of attachments 2. Control access to each attachment - Who can view, edit, remove 3. Enforce Business Rules about when and what types of attachments must be present 4. Auditing 5. In/Out bound email attachments - tying these to the correct record 6. etc Doug Tanner Remedy Skilled Professional (RSP) Former - Remedy Approved Consultant (RAC) ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Friday, January 25, 2008 11:02 AM To: arslist@ARSLIST.ORG Subject: Lots of Attachments Hello List, I'm building a form on ARS and one of the requirements from the client is an attachment pool. They want to have the ability to add up to 50 attachments. However, not every entry will actually use this many attachments. In fact, most of the requests they enter in this form will not use any of these attachment areas. Anyone have any suggestions for a work around? Or, just any thoughts about the impact of having that many empty attachment areas out there? Regards, -Matt Matthew C. Gayford Technology Research & Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"