The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

The FileMaker Relationinfo Function – FileMaker Today

Get real time updates directly on you device, subscribe now.


The Relationinfo function will allow you to return information about table occurrences and interlocking relationships. You need to specify within the syntax of the function which file and which table. The function will return 4 lines of information for each relationship to the parameter defined table occurrence. The first line returned is the file name, the second line will have the name of the child table occurrence, the third row will describe any relationship options that are set such as create related, sorting and deleting and the last row will tell you about the match fields used in the relationship.


Each different relationship will be returned in the list separated by double carriage returns.


Here are some examples returned using this function in the database I use to store my blog posts.


The syntax of my calculation is …


RelationInfo ( Get ( FileName ) ; “Blog” )


and the returned results include …


Source:Blog Stuff

Table:blog_Chapter_ValueList

Options:Create

blog_Chapter_ValueList::Chapter = Blog::Chapter


Source:Blog Stuff

Table:blog_Crosswords

Options:Create

blog_Crosswords::fk_blogLink = Blog::pk_recordID


Source:Blog Stuff

Table:blog_TERMS

Options:Create

blog_TERMS::fk_blogID = Blog::pk_recordID


Source:Blog Stuff

Table:blog_QUIZ

Options:Create

blog_QUIZ::fk_Blog_Id = Blog::pk_recordID


Source:Blogz_IMAGES

Table:blog_IMAGES

Options:Create

blog_IMAGES::pk_recordID = Blog::pk_recordID


More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..


© 2010 – Dwayne Wright – dwaynewright.com

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More