Tyrone, Use a Set Fields command that sets the attachment field to a temp char field. This will populate the temp char field with the name of the file. From here, you can test to see if certain text is inside the filename.
Personal preference: If you are going to use this command multiple times and/or on multiple forms create a SQL function in your DBMS. The function would have two parameters - the text to search and the word to search for. It would return 1 or 0 (or 'Yes' or 'No'). I prefer making one call to a function instead of having to recreate the functionality over and over in Filters and Active Links. Stephen ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee Sent: Tuesday, November 28, 2006 9:18 PM To: arslist@ARSLIST.ORG Subject: Question: Attachments ** I need to check to see if a user adds an attachment to any one of the 10 attachments where the file name contains "sow" or "SOW" in the file name. I am not quite sure how to do this - any help would be greatly appreciated. Thanks. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
