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

    RelationShip info



      RelationShip info




           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.



        • 1. Re: RelationShip info

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


          • 2. Re: RelationShip info

                 Hi Ben

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


                 Misha Mahto
                 Software Developer
                 FileMaker 11 Certified Developer


            • 3. Re: RelationShip info

                   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.




              • 4. Re: RelationShip info


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

                     here it is


                • 5. Re: RelationShip info

                       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