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.
On the Relastionship graph page under the Tools icons, select the Letter A for notes.
You can use RelationInfo ( fileName ; tableName ) function result to write in the notes. It might be helpful.
FileMaker 11 Certified Developer
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.
my attachment (Paste done in the text) were not posted.
here it is
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 fun
Retrieving data ...