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] On Behalf Of Micheal Gere Sent: Tuesday, August 21, 2007 11:31 AM To: arslist@ARSLIST.ORG 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"
