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:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)MY STANDARD LIST OF FILEMAKER LINKSThe White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates
By Richard Carlton Consulting
Starting Point - Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
Donations - Accounts | Contacts | Donations | Reporting | Prefs
Data4Life - Contacts | Calendar | Projects | Prospects | Journal | Goals
RCC Blog -
By yzysoft.com Contacts | Products | Invoices | Letters
Sample Database -
A free calendar is available and can be integrated into your database
Seedcode Calendar Free -
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 -
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/
Mac - http://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)
YouTube - Filemaker Videos
UK FileMaker Channel
FileMaker, Inc. Channel
Lynda.com Channel - Filemaker videos
Dwayn Wright's Channel
Soliant Consulting Channel
Filemaker Academy Channel
Skeleton Key Channel
Accelerate Computer Training Channel
Filemaker NewsScoop.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 -
Filemaker - Version By Version -
Search specific Filemaker sites with this Custom Google Search
Can you describe what you are doing in more detail? It's not at all clear what you are doing here.
I am basically importing name and address information into seperate Layouts. EG:
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.
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.
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?
Could some of them have more or less than 2 numeric digits after the CV?
If so, try CV* or just CV
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!
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...
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.????
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.