3 Replies Latest reply on Sep 12, 2012 7:55 AM by obidon

    Best Practice



      Best Practice


           As I move through to a more intermeadiat stage of knowledge, I worry about creating legacy issues for myself and my clients.  Can somebody point me in the direction of where I can obtain best practice advice please



        • 1. Re: Best Practice


               I have found the best way to assure a good Legacy is to document with comments so others can follow your logic and concepts.


               If you will follow this forum, you will quickly find the top advisors on good practise.  They are very helpfull and patient too.


          • 2. Re: Best Practice


            Home > Using FileMaker Pro Advanced > Using FileMaker Pro Advanced tools > Documenting database schemas (FileMaker Pro Advanced)

                 Documenting database schemas (FileMaker Pro Advanced)
                 Use the Database Design Report feature to document the schema of your database and publish it in to an HTML or XML file.
                 With the Database Design Report, you can:
                                          produce reports for any databases that are currently open, either locally or on a network
                                          gather statistics on the structure of your database
                                          use the information in the report to recreate the structure of your database if you lose the original database files
                                          examine a textual representation of your database schema
                                          choose which elements (fields, relationships, scripts, and so on) and tables of the database to document
                                     troubleshoot missing references, broken relationships, calculations, and more


            Home > Designing and creating databases > Creating a database > About planning 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  - 

            Background - Coding Standards - FileMaker Coding Standards

                 In 2005, FileMaker Inc. released a white paper which proposed possible methodologies and conventions under which a FileMaker developer could guide their development of a FileMaker solution. It was both a collaboration and contained contributions from a number of well-respected developers.

                 Here is the PDF: FileMaker Development Conventions
                 For this very reason, I present the genesis of the "ISO Standards for FileMaker Development".



            • 3. Re: Best Practice

                   Thank you gents, a little (more) bed time reading for me then smiley