![filemaker pro 6 reason to upgrade filemaker pro 6 reason to upgrade](https://flylib.com/books/2/582/1/html/2/images/21fig02.jpg)
I will develop it in FM11, so FM12/13 users can convert it.ĮDIT: Link to a database with this method used (via my Dropbox) I will work on a small database I'd like to share containing exactly this.
#FILEMAKER PRO 6 REASON TO UPGRADE FREE#
Please feel free to comment, adjust and find any flaws with using this method. the PEO anchor could be related to the ORG anchor. I just have to press HOME or COMMAND + UP.įor those with graphs containing anchors attached to anchors. I also create a Globals table which has the occurrence _Globals which I use everywhere for ease of access in the list. This method helps me speed up developments within a database I'm familiar with. INV could mean invitations, invoices or inventory. Some acronyms can mean the same thing and might be confusing. (The primary address of all the manufacturers of all the products in each invoice line of each invoice of the organization). org_inv_invli_prod_manuf_ADRprimary could need a few looks at the legend. The source of each occurrence is marked by the acronym in upper case.ĭisadvantages: Having a chain of occurrence of more than 5 could be confusing for new users not used to the solution. The logical meaning and path each occurrence has is self-evident by only having to look at the relationship list in the calculations dialog. A legend containing all the meaning of the acronyms is present at the very top of the relationship list in the calculations dialog. peo_orgPrimary_ADRprimaryĪdvantages: All the occurrences are grouped together by Anchor and buoy in the relationship list in the calculation dialog. Relationship is only the primary address of the organization. peo_ORGprimary is linekd to an occurrence of Address(ADR). The previous reasons will be title case, leaving only the current reason camel case.Įx. The previous acronyms will be lower case leaving only the current acronym as upper case. The following buoys attached to other buoys will transport the whole name of the one linked, but with case changed.The relationship is only returns the one which is flagged as primary. The People(PEO) main anchor is linked to a Organization(ORG) buoy. Lower(Acronym of the anchor) & "_" & Upper(Acronym of the buoy) & if(evident buoy "" camelCase(reason for this buoy)).Įx. For each buoy, the pattern will be as follows.
![filemaker pro 6 reason to upgrade filemaker pro 6 reason to upgrade](https://images.techhive.com/images/idge/imported/imageapi/2014/08/20/16/filemakergo13_0-100387489-orig.jpg)
You should now have all of your anchors.Place that occurrence (created in 3) somewhere in the graph, along with all the others of the same pattern.Create a table occurrence with the source table of the newly created table named "_" & Upper(Acronym) & "_" & Title(Table name).The occurrence "People" created when I created the table "People" will be renamed "PEO". Rename the first occurrence created automatically in the graph exactly with the acronym in capital letters.Įx.The table "People" would have the acronym "PEO" For each table, find a small acronym (between 3 and 5 letters) that will represent the table.Įx.My method is mostly used for Anchor/Buoy relationship graphs, but I assume it can be well used in other methods with small changes.