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

    Best Practice

    obidon

      Title

      Best Practice

      Post

           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

            

           Don

        • 1. Re: Best Practice
          JimMac

               Opinion...

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

               However..

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

               Jim...

          • 2. Re: Best Practice
            davidanders

            http://www.filemaker.com/11help/html/fmpa_tools.24.5.html

            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:
                 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)

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

            Background - Coding Standards - FileMaker Coding Standards
            http://filemakerstandards.org/display/cs/Background

                 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
              obidon

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