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] 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"