5 Replies Latest reply on May 1, 2013 10:15 PM by JimMac

    RelationShip info

    bkaisin

      Title

      RelationShip info

      Post

           Hello,

            

           It will be great to be able to write an info for each relationship (in the graph) and not only general notes.

           I am working on a complex database (more than 300 relationships) and it will really help.

           Thanks

           Ben

        • 1. Re: RelationShip info
          JimMac

               On the Relastionship graph page under the Tools icons, select the Letter A for notes.

               Jim...

          • 2. Re: RelationShip info
            misham

                 Hi Ben

                 You can use RelationInfo ( fileName ; tableName ) function result to write in the notes. It might be helpful.

                  

                 Thanks
                 Misha Mahto
                 Software Developer
                 http://mindfiresolutions.com
                 FileMaker 11 Certified Developer

                  

            • 3. Re: RelationShip info
              bkaisin

                   Thank you for your answers.

                   But unfortunatelly this is not enough for me.

                   As you can see hereunder, I use the notes to separate the groups of relations.

                   When you have a lot of relationships, sometimes it's not easy to remember the purpose of a specific relation.

                   The only solution that I found is to create a database design report and find in Safari where is this relation used.

                   It should be great if FileMaker add an info box in the dialog of each relation.

                   This is my actual development (hospital managment), not done yet.

                   Regards

                   Ben

                    

              • 4. Re: RelationShip info
                bkaisin

                     Ooops,

                     my attachment (Paste done in the text) were not posted.

                     here it is

                     Ben

                • 5. Re: RelationShip info
                  JimMac

                       The problem is your graphs are too close together.  Nice picture, but is very crowded.  Perhaps spread them out and then the notes would be guides.

                       Also i try to be color and title consistant, which is fastest way to read in scripts.  Like blue for all personnel, dark blue for central or core items and light blues for related files.   Titles like  Employee_Salary and Employee_Vacation  and Employee_Annual Reviews  [pk_fk type pattern].

                       Documentation is always funyes

                       Jim...