Ray,
A filter on Submit (and/or Modify) is what your after.
Assuming you want to set the 'SQLFilter' field anytime 'Field1' or
'Field2' values are changed by the user then the Run If would need to
be something like....
('DB.Field1' != 'Field1' OR 'DB.Field2' != 'Field2')
Next you would need only one If Action. It would be a Set Field action
where you set the value of 'SQLFilter' to this...
"Customer = " +$Field1$+" AND Severity = "+$Field2$
And that should get you want your after.
HTH
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 7/26/07, Ray <[EMAIL PROTECTED]> wrote:
> 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"
