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.
Documenting database schemas (FileMaker Pro Advanced)Use thefeature to document the of your database and publish it in to an or 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 (, , , and so on) and tables of the database to documenttroubleshoot missing references, broken relationships, calculations, and moreAbout planning a databaseA 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 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".