Over 46,000+ Business Solution Developers Find answers, ask questions, and connect with our community of business solutions developers, business owners and partners.
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