1 Reply Latest reply on Oct 26, 2012 1:58 PM by davidanders






           So Infinity has purchased FMP12. And now I have a few additional questions...


           ~ How do you link fields together? What I mean is, I have created so far only a replication of the registration form we use for every music student. How can I make it so I can look up just phone numbers, or just by school? 

           ~ I also was wondering how to set up another database to keep track of inventory like equipment, music & art literature, much like a library. And lastly, I really want to use FMP to track our payments. So to give you an idea of what that looks like - we currently have 196 students taking lessons throughout the week. They all pay program fees monthly. We ask that they pay at the beginning of the month, but there are always stragglers and I often have to write out reminders. I would LOVE a way to streamline all of this. 

           ~ Infinity is also looking into trying to find a "FileMaker Pro" as in someone who could come in and teach us how to best utilize the program to suit our needs. Once we find a person to do such a day of teaching, we would find a grant to bring that person to our facility. Any suggestions would be greatly appreciated!


           Thanks everyone!!


        • 1. Re: Links?
          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)


          The 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
                                                            Recruiter -
                                                            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

          Hints, Tips, and Demo Downloads  FMP version 6 thru 12

          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/

                                                            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

          FMTutorials Channel
                                                            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 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  - 
                                                            Filemaker - Version By Version  - 

          Search specific Filemaker sites with this Custom Google Search