Don't put the quotes around the field names. Like this: 'Product' LIKE $Product$ + "%"
Instead of this: "'Product' LIKE $Product$ + "%"" -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Tuesday, October 02, 2007 1:59 PM To: arslist@ARSLIST.ORG Subject: Why does this set fields action fail? ** Hey everyone- Hopefully this will be a simple question for someone! I made a display only form to act as sort of a QM control panel. There is a form on our system called AllTickets which contains basic information on all types of tickets- ID, Summary, Status, etc. The form I made has a table and 2 character fields with menus that correspond to fields on AllTickets. The idea is that users can select an item from the menu and get a list of all records on AllTickets that match. Once the user chooses a menu item, an active link sets a hidden field (mdwAllTicketQualification/mdwAllTicketQualificationRelease) for a qualification for the table. The table qualification is (EXTERNAL( $mdwAllTicketQualification$)) AND (EXTERNAL( $mdwAllTicketQualificationRelease$)) AND ( 'mdwLISTTicketNumber' LIKE ( "QM" + "%" )) AND ( 'mdwLISTStatus' != "Closed" ) AND ( 'mdwLISTStatus' != "Resolved" ) AND ( 'mdwLISTStatus' != "Rejected" ) AND ( 'mdwLISTStatus' != "Canceled" ) This works fine if I use an exact match: 'Product' LIKE $Product$ or 'Release' LIKE $Release$. However, we have a product called Classified. There are several versions, stored as Classifieds 2.x for example, so I want to be able to use wildcards. If I paste 'Product' LIKE $Product$ + "%" directly into mdwAllTicketQualification, it does what I want it to do and returns all records that start with Classifieds, but if I try and get an active link to set "'Product' LIKE $Product$ + "%"" into the field, I get an error that says "Data values are not appropriate for arithmetic operation." Apparently it's treating the % like a literal character. What do I have to do to get that string set into the field? I hope this is clear- let me know if you need clarification on the process. Thanks, Chris __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"