David this worked out great so thanks. One new wrinkle that was introduced the other day. Not only do they want to see every ISBN that matches, they want to see every ISBN that does not match. Any ideas?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Monday, July 24, 2006 4:39 PM To: arslist@ARSLIST.ORG Subject: Re: How to perform a single search of multiple items and return all the matching records??? Hi Brian I think you should be able to do this with a simple table field qualification. Say you have a form with a field containing the string of ISBN values in a field called ISBN List, and a table field pointing to your book records which have an ISBN data field. Normally for a table field you would have a qualification like ( 'DataTableField' LIKE ( $CurrentFormField$ + "%" )). In this case you need to turn the qualification round, like $ISBN List$ LIKE (( "%" + 'ISBN') + "%" ) To allow the search to ignore the dashes, you would need a 'shadow' field on your book asset record (set by a filter) containg a stripped version of the ISBN. Then you could change the table field qualification to ($ISBN List$ LIKE (( "%" + 'ISBN') + "%" )) OR ($ISBN List$ LIKE (( "%" + 'ISBNStripped') + "%" )) It won't be the most efficient query, but it should work HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk On 7/24/06, Sokol, Brian <[EMAIL PROTECTED]> wrote: > I have been asked to replace a Filemaker Pro database with a Remedy > application. We are a book publisher and this application is used to > request digital assets by their ISBN number. Each asset has their own > unique ISBN number. In Filemaker they can cut and paste a long list of > ISBN numbers and search using that list. The results will show every > match made against a table of about 60K records. Additionally the ISBN > list may be formatted with dashes or unformatted with just the number. > > Is something like this possible? > > Brian Sokol > Manager, Desktop Services > Scholastic Inc. > 212-343-7698 > [EMAIL PROTECTED] > <http://www.scholastic.com> > > ________________________________________________________________________ ____ ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org