Hi David, Thanks for the quick response. This is giving the same results I was getting. If I enter 12345 for the ISBN number and this does not match my database, it is returning every record from your xBookDetails table. What I need to accomplish is to paste a list of ISBNs into a character field, click on a button and populate 2 tables. Table 1 shows all the matches. This works now. Table 2 will show only those ISBNs that I was searching for and did not find. So for example if your xBookDetails table had records for the following ISBNs: 11111 22222 33333 44444
And I searched for the following: 22222 44444 55555 66666 My results should look like this: Table 1 (matches): 22222 44444 Table 2 (non-matches): 55555 66666 What I currently get for a non-match is: 11111 33333 Hope this explains this better. Thanks Brian -----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: [email protected] 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
