You should be able to use the LIKE operator for that. When you append values, the character field holds multiple string values. One value is easy. Say "Florida" is the one value in the field. Then you can just use equals as the operator.
When you append, however, the string becomes more complicated, as you suggested. Now it might be "Florida Ohio". That's where the LIKE operator comes in. Use LIKE instead of equals and use the % wildcard. Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Micheal Gere Sent: Tuesday, August 21, 2007 1:04 PM To: [email protected] Subject: Re: Table Field qualification ** Hi Norm Thanks for your reply.. Let me explain the requirement in a more articulate way... When a user selects a value from the menu on the LOCATION field ( say ILLINOIS) and a value from the menu on the POSITION field ( say Supervisor) the table field gets the data pertaining to all supervisors from Illinois.. Now the requirement is they want to select the multiple Locations ( Illinois, Indiana etc.... ) and multiple positions ( Supervisors, Managers etc..) and they want the table field to show the data. I am not sure how I set the qualification for values appended... Any ideas Thanks Mike On 8/21/07, Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> wrote: Why not just change the table qualification to $LOCATION$ LIKE "%" + 'LOCATION' = "%" AND $POSITION$ LIKE "%" + 'POSITION' + "%" ?? Sorry if I'm misunderstanding the issue and oversimplifying it. Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto: [email protected] <mailto:[email protected]> ] On Behalf Of Micheal Gere Sent: Tuesday, August 21, 2007 11:31 AM To: [email protected] Subject: Table Field qualification ** Hello Everyone I hope somebody can answer this... I have a form with the following fields LOCATION - A character field with a menu append POSITION - A character field with a menu append TABLE - A table field whose source form is a JOIN form of employee location and employee position. This table gets refreshed and fetches the data based on the user selection of LOCATION and POSITION. Table qualification is (( 'LOCATION' = $LOCATION$) AND ('POSITION' = $POSITION$)) Now when the menu is appended and I have multiple values in the LOCATION and POSITION fields, how would I set the table qualification ? I am guessing it can be done using some External qualification but not sure how ? Thanks in advance for your time Gere __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
