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"
