Greetings List! I've been asked to build a feature that searches multiple fields at once. I've got some thoughts on how to accomplish this, but I was wondering if there were any hints/tips/suggestions/"watch out" points that you all may have out there.
Here's what I have so far: 1) Display only form 2) Search Criteria field 3) Form Selection field (Search menu using the Data Dictionary) 4) Multiple tables (hidden unless its form = Form Selection field) showing key information from each form (with drill down option available) Tables would be setup with qualifications something like: 'FieldA' LIKE "%"+$Search Criteria$+"%" OR 'FieldB' LIKE "%"+$Search Criteria$+"%"........ Any thoughts/advise/etc. on this approach? Thanks in advance for your help! Shawn Stonequist Remedy 6.3 EMNS, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
