1 Reply Latest reply on Jan 16, 2010 10:57 AM by davidanders

    How to best document a database?

    LeoB

      Title

      How to best document a database?

      Post

      First -- I'm NOT a database professional.  I've got a death grip on reckless amateur status.

       

      I've created a database to use in my work in FP10 with three tables, one very large table and two smaller supporting tables.  My design document was substantially changed as I learned things (mostly from this forum) and reduced the database from nine tables to three.

       

      I've been trying to do documentation as I go along using paper, pencil, and a BIG eraser.  But, I'm not sure I'm capturing everything I should.  I'm not using anything fancy (yet) like script triggers, global fields, etc. 

       

      I've searched this forum and other places for a good example of database documentation for FP10 or Access and found one or two, but those were for SQL databases.  I want to start converting the documentation into Word or Excel (any preference?), but it would make it easier if I formatted it halfway right from the beginning.

       

      Any recommendations?