Documenting relationships

[john9210]

I have been using FM for quite a few years now. One thing I'm disappointed in is that you cannot name relationships. I always document my own databases and use the following procedure for documenting each relationship:

The relationship is named with the table occurrences (TOs) involved in the relationship.

TO1-to-TO1

Example

Assume there are two related tables Customers and Items:

Comments

Relationship name

Customers-to-Items

TO names

Match fields

Customers::pkRecordID = Items::fkRecordID

Include TO names

Create records

Items

TO where records are created

Delete records

No

TO where records are deleted

Sort

Yes; Item name, ascending

How records are sorted

I would be interested in knowing how others document relationships so I could improve my procedure. Any suggestions and/or comments?

Sorry. I prepared the topic with a table, and it came out garbled. I'll try to attach a Word document.

I would be interested in knowing how others document relationships so I could improve my procedure. Any suggestions and/or comments?

[beverly]

Relationships.xsl.zip Yes! run the DDR and apply an XSLT with an import back into FileMaker!