Ray et al., You mentioned that the user can fill in Field1 "and/or" Field2. If you are going to leave it so that the values of either Field1 or Field2 could be left blank, then you'll need to make several Active Links to test for the various conditions and set your SQLFilter string accordingly. Leaving one of the fields blank would probably produce unexpected results in your concatenated string if you don't.
Best of luck, Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Friday, July 27, 2007 7:44 AM To: arslist@ARSLIST.ORG Subject: Re: Populating a field based on values for other fields plus some string Ray, This can be done by Filter or Active link (Filter if the SQLFilter field is on a different form than the one your user is saving) You can use a simple "Set Fields" action (or Push Fields if sending to a different form) Under the "Fields" section of the If or Else tab, select "SQLFilter" from the drop down menu, then use the following for "Value:" "Customer = " + $Field1$ + " AND Severity = " + $Field2$ Remember to use the double quotes (") around any text/strings and the dollar signs around any dynamic values you wish to use. HTH Shawn Stonequist EMNS Inc. -----Original Message----- From: Ray [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 9:14 PM Subject: Populating a field based on values for other fields plus some string Hi: I have three fields called Field1, Field2 and SQLFilter in a form. User provides data for Field1and or Field2. When the user hits the save button, I want to populate the SQLFilter field with the following string Customer = 'Value of Field1' AND Severity = Value of Field2 I am thinking I have to use a filter. Not sure how to go about it. Can someone help Thanks Ray ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"