10 Replies Latest reply on Oct 9, 2012 6:48 AM by philmodjunk

    Multiple Find Requests

    PhilHopkinson

      Title

      Multiple Find Requests

      Post

           Hi All,

           I am having problems trying to get multiple find requests, I have used the CMD + N command which has produced the right results, but then I need to add a file ref search, which brings up more than one ref and thats not correct.

           The first search is for Post codes 44 in total, this is so I can remove them or see what post codes are in the file, then I want to pull up the file ref so I am only searching from a certain file.

           I decided to reimport the file again in a new Layout, but then I have found you cant use the same find request, which means each time i would have to add 44 post codes manualy, I am beginning to think Microsoft Access was a better option, but because I am a Mac user I was recommeded this!

            

           Somene please help.

           :(

        • 1. Re: Multiple Find Requests
          davidanders

               What type of records are you searching?  What are Post Codes? Reimport from what program? Find requests can be saved in scripts.
               Coke or Pepsi, arguments can be made for either.


          http://www.filemaker.com/11help/html/create_db.8.2.html#1027557
          Home > Designing and creating databases > Creating a database > About planning a database
                         A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.                
                              Follow these general steps to plan a database:
          <SNIP>

          http://help.filemaker.com/app/answers/detail/a_id/3248/related/1
          Relational Database Design 101 (part 1 of 3): Designing a Flat File Database

          http://help.filemaker.com/app/answers/detail/a_id/3247/related/1
          Relational Database Design 101 (part 2 of 3)

          http://help.filemaker.com/app/answers/detail/a_id/3246/related/1
          Relational Database Design 101 (part 3 of 3)



          MY STANDARD LIST OF FILEMAKER LINKS

          The White Paper for FMP Novices is useful  - 
                                                       http://foundationdbs.com/downloads.html
                                                       
                                                       Filemaker Free - Listing of free resources  - 
                                                       http://filemakerfree.com/


          Free unlocked templates
                                                       By Richard Carlton Consulting
                                                       Starting Point -  Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
                                                       http://fmstartingpoint.com/
                                                       Donations -  Accounts | Contacts | Donations | Reporting | Prefs
                                                       http://filemakerdonations.com/
                                                       Recruiter -
                                                       http://rccrecruiter.com/alt-index.html/
                                                       Data4Life -  Contacts | Calendar | Projects | Prospects | Journal | Goals
                                                       http://data4life.net/

          RCC Blog  - 
                                                       http://filemakerbits.wordpress.com/
                                                       
                                                       By yzysoft.com  Contacts | Products | Invoices | Letters
                                                       Sample Database -
                                                       http://yzysoft.com/printouts/yzysoft_SampleDatabase.html

                                                       
                                                       A free calendar is available and can be integrated into your database
                                                       Seedcode Calendar Free -
                                                       http://seedcode.com/cp-app/prod/calendarfree10/
                                                       
                                                       Filemaker's  Online Help Pages
                                                       FMP 12  http://www.filemaker.com/12help/index.html
                                                       FMP 11  http://www.filemaker.com/11help/index.html
                                                       FMP 9    http://www.filemaker.com/9help/index.html


          FMP business database demos - some are fully useable
                                                       The Excelisys Business Tracker V3.0  - 
                                                       http://excelisys.com/exbiztracker3.php/
                                                       
                                                       Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
                                                       Google "Campus Productivity Kit"    https://www.google.com/search?q="Campus+Productivity+Kit"

          WIN -  http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577579.html/
                                                       Machttp://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577567.html/

                                                       You can rename the database from a .usr file to a .fp7 file and open in FMP 7 thru 11

          Lynda dot com has Filemaker Videos (portions are free)
                                                       http://lynda.com/FileMaker-training-tutorials/116-0.html
                                                       
                                                       YouTube - Filemaker Videos

          FMTutorials Channel
                                                       http://www.youtube.com/user/FmTutorials/
                                                       
                                                       UK FileMaker Channel
                                                       http://youtube.com/user/UKFileMaker/
                                                       
                                                       FileMaker, Inc. Channel
                                                       http://youtube.com/user/filemakerinc/
                                                       
                                                       Lynda.com Channel - Filemaker videos
                                                       http://youtube.com/user/lyndapodcast/videos?query=filemaker
                                                       
                                                       Dwayn Wright's Channel
                                                       http://youtube.com/user/FileMakerThoughts/


                                                       Soliant Consulting Channel
          https://youtube.com/user/SoliantConsultingTV/

          Filemaker Academy Channel
                                                       https://youtube.com/user/filemakeracademy/
                                                       
                                                       Skeleton Key Channel
                                                       http://youtube.com/user/SkeletonKeySTL/


                                                       Accelerate Computer Training Channel
          http://youtube.com/user/AccelerateTraining/
                                                       
                                                       Filemaker News

          Scoop.it is an information curation site - free option available.
                                                       Filemaker Info  -  http://scoop.it/t/filemaker-info
                                                       Filemaker News  - http://www.scoop.it/t/fm-news

          Filemaker Wikipedia  - 
                                                       http://en.wikipedia.org/wiki/FileMaker
                                                       
                                                       Filemaker - Version By Version  - 
                                                       http://tokerud.com/filemaker/


          Search specific Filemaker sites with this Custom Google Search
          http://www.google.com/cse/home?cx=001044389222327874554:vi8it1bulm8
                                                        

                

          • 2. Re: Multiple Find Requests
            philmodjunk

                 Can you describe what you are doing in more detail? It's not at all clear what you are doing here.

            • 3. Re: Multiple Find Requests
              PhilHopkinson

                   Hi,

                   I am basically importing name and address information into seperate Layouts. EG:
                   Funeral
                   Solar
                   Debt
                   Sky 
                   Each file has a column header from excell called "File Ref" I then search one of the layouts in file ref for example FUN071012 would produce from the find request 809 records matching the ref: FUN071012, I then need to drill down further into the 809 records and pull up records matching the Post code field.

                   I have tried to add another request but this does not bring up the results it tells me the search has 1253 records so it must be looking at the whole base and not the 809 records.

                   Regards

                    

                    

              • 4. Re: Multiple Find Requests
                philmodjunk

                     When you add a second request, you are using inclusive find logic: "find all records with file ref "FUN071012" OR that have the specified post code.

                     Put both criteria into the same request and then the logic becomes AND instead of OR.

                     You can also refine the results of one find request by returning to find mode, specifying your criteria and then selecting "constrain found set" from the records menu instead of Perform Find.

                     Please note that I am assuming that you are searching a single table from a single layout with this criteria. Also please note that a "layout" and a "table" are not the same thing even though you frequently have both a layout and a table with exactly the same name.

                • 5. Re: Multiple Find Requests
                  PhilHopkinson

                       Hi,

                       Thanks for the reply, it almost works the only problem I am having is some of the data is not being brought up on a search for example I look at the 809 records and find the Coventry Post Code which is CV21 7GH so to find this I put CV## in the post code box, the results are 7 records.

                       But when I Omit these and look at whats left there are still Post codes with CV in the list, what should I type to ensure I get all of them?

                        

                       Thanks

                        

                  • 6. Re: Multiple Find Requests
                    philmodjunk

                         Could some of them have more or less than 2 numeric digits after the CV?

                         If so, try CV* or just CV

                    • 7. Re: Multiple Find Requests
                      PhilHopkinson

                           Hi thanks again,

                            

                           i have tried the above and for some reason it still does not work, it does work if you put the post code on its own this makes no sense to me!

                      • 8. Re: Multiple Find Requests
                        philmodjunk

                             Is the field defined as type text or type number? It should be text but a number field in FileMaker will allow you to enter text as well as numbers and all looks fine until you have to sort or search on it...

                        • 9. Re: Multiple Find Requests
                          PhilHopkinson

                               Hi Thanks Again,

                                

                               Its a Text field, I have tried many diffrent methods and it seems that Filemaker is not reliable enough for me, I have had to resort back to my manual method of using Excell, where I sort the file by post code, putting them all alphabeticaly>

                               Then I just search for each post code individually and remove the ones its finds, at least this way I know the final figure is correct and the data that remains is the right data.

                               Each time I ran this in file maker I got diffrent answers.

                               EG I had 809 Records
                               I Then asked it to find the Post codes B,CV I then get results with 711 or 702 the total of B and CV is 65 so it should leave 744 which is what I got from doing it in Excell.

                               I dont think I can trust filemaker to get this right each time and I can't afford to not send the correct data to my clients.????

                                

                               Thanks

                          • 10. Re: Multiple Find Requests
                            philmodjunk

                                 I think you need to describe your data and your actions in more detail. FileMaker is quite reliable when it comes to searches and sorts. If you are getting different results each time, that suggests one of two possibilities:1) the find method used each time was not identical or 2 ) (Unlikely but possible) your field index where you are specifying search criteria has become damaged for some reason.

                                 Indexes can easily be rebuilt to rule out that possibility. You can also upload a file to a sharing site and post the down load link here if you'd like me to take a quick look at it.