{"id":8551,"date":"2015-02-24T05:20:02","date_gmt":"2015-02-24T13:20:02","guid":{"rendered":"http:\/\/www.seedcode.com\/?p=8551"},"modified":"2023-08-08T16:31:40","modified_gmt":"2023-08-08T16:31:40","slug":"filemaker-data-modeling-with-selector-connector","status":"publish","type":"post","link":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/","title":{"rendered":"FileMaker Data Modeling with Selector Connector"},"content":{"rendered":"

Overview<\/h2>\n

The Selector-Connector is a data model for organizing your FileMaker table occurrence graph. It is something we’ve been loosely collaborating on with our friend and colleague Todd Geist<\/a>. I say loosely, because during the evolution of the model, we never really reviewed each others work, but talked in very general terms about our progress. The fact that we ended up with something so functionally similar makes me think that we’re actually onto something! Todd has a great post and video on his approach\u00a0here<\/a>.<\/p>\n

\n
\"\"
The new SeedCode Complete template<\/figcaption><\/figure>\n<\/div>\n

We’re also using\u00a0Selector-Connector as\u00a0the data model for the new\u00a0\u00a0SeedCode Complete<\/a> and it is one of the primary reasons we feel\u00a0Complete is working so well; seeing how\u00a0Selector-Connector is letting folks extend and modify Complete also\u00a0tells us this approach is being validated.<\/p>\n

The most important thing to me about the Selector-Connector model is that the techniques themselves are not new new at all. It uses powerful, native techniques that have been around since FileMaker 7–like global keys and cross-joins–but it organizes them as a pattern\u00a0that we can describe, much like we can describe the Anchor-Buoy pattern.<\/p>\n

FileMaker Data Models: Extending Anchor-Buoy<\/h2>\n

The Selector-Connector should be seen as\u00a0an extension of the currently predominant data model, Anchor-Buoy<\/a>. Anchor-Buoy is arguably the most widely adopted FileMaker standard in the development community, and there are two very good reasons for that.<\/p>\n

    \n
  1. It organizes the graph very clearly with a small set of rules<\/li>\n
  2. It has a great name that is very visually descriptive.<\/li>\n<\/ol>\n

    We want to make sure we don’t lose either of those things \u00a0if we’re going to tinker with the model. In general terms, Selector-Connector keeps the current Anchor-Buoy model but builds “on top of it.” We’re just going to “bend” its rules a little bit.<\/p>\n

    A very basic interpretation of the Anchor-Buoy rules would be:<\/p>\n

      \n
    1. All layouts must reference Anchor Table Occurrences<\/li>\n
    2. Interacting with Buoys is only done from the context of their Anchor<\/li>\n
    3. Anchor Table Occurrences\u00a0cannot be related to each other.<\/li>\n<\/ol>\n

      By sticking to these rules, the Anchor-Buoy model forces us to be aware of context and it also limits the chance of us doing an operation out of context, like picking the wrong table occurrence for a portal; very important things in FileMaker and generally these benefits have outweighed the draw-backs of Anchor-Buoy, and that’s why it’s the standard.<\/p>\n

      \n
      \"FileMaker<\/a>
      Typical Anchor-Buoy model in action<\/figcaption><\/figure>\n<\/div>\n

      The Pop-Over Cometh<\/h2>\n

      As I mentioned above, there’s nothing technically new to the Selector-Connector model. So what\u00a0changed to start us down this road? For me, it was the introduction of the Pop-Over in FileMaker 13. Here was a great new object that would be a light weight alternative to pop-up windows and dialogs. <\/p>\n

      It would be great for picking records from a portal, and for editing and creating records. And, using the new slide panels, selecting, creating, and editing, could be done all in one place! FileMaker Inc. seemed to have a similar thing in mind as the demo files that came with 13 had a nice example of this “all in one place” behavior: bring up a pop-over with a portal and filter for the record you’re looking for. If you can’t find it, then hit new and “slide” to a new record form right in the same pop-over…very slick! We were starting to work on the new SeedCode Complete<\/a>\u00a0and I saw a great design pattern taking shape.<\/p>\n

      \n
      \"FileMaker<\/a>
      A simple Pop-Over with Picker Panel and then a New Contact Panel<\/figcaption><\/figure>\n<\/div>\n

      However, when I started exploring this, I realized (obviously) that these pop-overs would have to be done as single purpose objects: even though both Projects and\u00a0Invoices would need to pick Contacts, I wouldn’t be able to use the same pop-over as it would be bound to the context of the Project or Invoice layout. Even if I was using a virtual list<\/a> for my Contact Picker, the portals would each still<\/em> need their own buoys attached to Projects and Invoices. This suddenly seemed like madness, and I was determined to find a way to copy and paste my pop-overs from Anchor to Anchor and have them work with very little modification.<\/p>\n

      Universal Context<\/h2>\n

      If we\u00a0wanted the pop-overs to work universally, then there was no way around it, we would need to have a context for them to work in, and the idea of Universal Context was born. For a long time, Todd and I were both using this description of the model as the Selector itself hadn’t taken form. Here’s a representation of our first pass.<\/p>\n

      \n
      \"The<\/a>
      Early Connector Model, aka Universal Context Model<\/figcaption><\/figure>\n<\/div>\n

      We decided to “compromise” on the Anchor-Buoy rule of Anchors being related to each other. We still don’t want them directly related to each other, or even interacting directly with each other. However, we do want them all to be able to access the Universal Context table occurrences of Home and Virtual List Rows. This way, any Anchor layout\u00a0can all use the same portal on our Pop-Over Selector. Not only can they use the same portal, but the scripts that reference the portal can also be generic: and we’re a little closer to having the\u00a0portable\u00a0pop-over we’re after!<\/p>\n

      What about Record Locking?<\/h2>\n

      The idea of the above graph is that I can set the RowsToShowGlob global field in Home and control the contents of my virtual list (setting a list of contacts to select from, for example). But what if another user\u00a0is trying to do the same thing? This isn’t a\u00a0Session Model<\/a>, and we don’t want to have to manage multiple records in Home to prevent record locking, so how can we get around that? It turns out that if the Home table only has global fields in it, you’ve, in essence, made it a global table that multiple people can interact with without locking. This was really a critical milestone in the process. By having a central\/single TO that we could connect through, we could enforce\u00a0a similar, although slightly looser, model as Anchor-Buoy.<\/p>\n

      It’s important to note\u00a0that we are interacting with the Home\u00a0and the Virtual List Rows from the context one of the Anchors, and when doing this the central TO does not lock. However, if you create a layout in the context of the Home layout, and open a related record from there, then you do lock that central table preventing another user from doing the same. Working with the “universal context” tables from the Anchor causes the Anchor record to be opened, and not Home, which is the behavior we want.\u00a0So, this is a rule from Anchor Buoy that needs to be maintained for this model to work: All user layouts should still be in the context of an “Anchor.”<\/p>\n

      Create From Anywhere<\/h2>\n

      The model above solved my problem of being able to use a\u00a0Contact Picker Pop-Over from any of my layouts, but I also wanted to be able to create new contacts right from my pop-over. Since we’ve already extended the Anchor-Buoy model for our Virtual List, we’ll extend it a little bit further and create\u00a0a dedicated TO for contact creation. So now you’ll see a table occcurence called CreateContacts hanging off our Home table occurrence below.<\/p>\n

      \n
      \"Creation-Relationships<\/a>
      Adding a Table Occurrence for creating contacts<\/figcaption><\/figure>\n<\/div>\n

      We can create new Contacts through this relationship. If the relationship between Home and CreateContacts is a creation relationship and the ContactIdGlob in home is empty, we can create a new Contact simply by typing into a field in the CreateContacts table occurrence. The Contact id is an auto-generate field and this value for the new record will be pushed back into the global. This behavior may seem a little strange, but has existed for as long as I can remember in FileMaker and is referred to as the “pop-back” or “magic key<\/a>.” For us it allows us to create a new Contact from anywhere by creating a temporary “parent” in Home, and we no longer need to go to a Contact layout to do this. We can use our Pop-Over Contact Picker on any layout to both pick and create contacts! Problem Solved and our graph is not a mess.<\/p>\n

      The Selector<\/h2>\n

      Soon after we got this part working, we began to realize that there was more we could do with this model. If we’re using this Universal Context to create records from anywhere, then we can also very easily use this same model to view and edit records from anywhere. Master Detail<\/a> or Selection Portals are very common in FileMaker, and we soon realized that the Universal Context would work great for them.<\/p>\n

      Typically an Anchor would\u00a0need two Buoys to a related table to do a proper Master Detail view. Normally we’d\u00a0click on a portal row of our first Buoy to get the id of the record we clicked. We would then set that id to a global to set up a relationship to the second Buoy where we would see additional data about the selected record. With Selector-Connector we can now set that global in our central Home Table Occurrence and use the relationship to CreateContact for our detail view. This means we can get rid of that second Buoy for the detail, and more importantly, any<\/strong> Anchor that wants to see Contact details can use that same Table Occurrence.<\/p>\n

      This is really the birth of the Selector. The central table is now no longer called Home, but the “Selector”. The table occurrences to its right are the “Selected”, and they’re also the relationships that let us create new records. We’ve now consolidated, pickers, creation and master-detail into a single “component” of the graph instead of a bunch of similar Buoys attached to each of your\u00a0Anchors.<\/p>\n

      \n
      \"The<\/a>
      The Selector Model Takes Shape<\/figcaption><\/figure>\n<\/div>\n

      \u00a0The Connector<\/h2>\n

      As we started working with this new model, there was this great sense of relief that we weren’t “fighting” with FileMaker like we have in the past. Context\u00a0and Layouts were still tied to the Anchors, and it was living up to the promise of being the best of both worlds! In addition, we\u00a0started to see\u00a0some residual\u00a0benefits.\u00a0\u00a0For one, since most of the global keys were being moved to the Selector, we didn’t need them in actual data tables anymore.\u00a0In SeedCode Complete, we were able to remove virtually all global fields from our the data tables. This keeps them much easier to work with, particularly if integrating with another data source or doing imports as you don’t need to wade through all the globals. This led to the idea of the Connector.<\/p>\n

      For me, the Connector is about modeling\u00a0the graph to not just symbolize what’s a layout and what isn’t, but the different logical components of the graph. Initially we were thinking we had just two\u00a0components, the Anchor-Buoy component and the Selector component, but once you adopt that model, it can be taken a little further. Really, the Selector is different than the Virtual List, so we decided to\u00a0make our graph represent that. We also\u00a0now have a place where we can keep indexed values available to all Anchors as well. Things like settings or graphics can also be cross-joined to our central Connector and accessed from anywhere<\/strong>. These things working together is the full Selector-Connector model.<\/p>\n

      \n
      \"The<\/a>
      The Selector Connector<\/figcaption><\/figure>\n<\/div>\n

      In conclusion, I’d like to remind you of this great Picasso quote my mother recited to\u00a0me for as long as I can remember, and how I think it applies here.<\/p>\n

      “Learn the rules like a pro, so you can break them like an artist.”<\/h2>\n

      -Pablo Picasso<\/p>\n

      After going through this exercise, I believe that Anchor Buoy was not necessarily what the developers of the graph had in mind, but it was an absolutely critical step in our collective development. The idea of approaching something like the Selector-Connector without a complete and thorough understanding of FileMaker Context would be daunting and probably fruitless. The only reason we can use, or even talk about, a model like this is because of what Anchor-Buoy has taught us, and I want to re-emphasize the idea that the Selector-Connector (as I see it) is an extension and\/or continuation of Anchor-Buoy. We’ve worked hard to learn and honor its rules, so we might be ready for a little artistry.<\/p>\n

      Need more? Checkout “Selector-Connector: the basics<\/a>“<\/p>\n","protected":false},"excerpt":{"rendered":"

      Overview The Selector-Connector is a data model for organizing your FileMaker table occurrence graph. It is something we’ve been loosely collaborating on with our friend and colleague Todd Geist. I say loosely, because during the evolution of the model, we never really reviewed each others work, but talked in very general terms about our progress. The fact that we ended up with something so functionally similar makes me think that we’re actually onto something! Todd has a great post and video on his approach\u00a0here. We’re also using\u00a0Selector-Connector as\u00a0the data model for the new\u00a0\u00a0SeedCode Complete and it is one of the primary reasons we feel\u00a0Complete is working so well; seeing how\u00a0Selector-Connector is letting folks extend and modify Complete also\u00a0tells us this approach is being validated. The most important thing to me about the Selector-Connector model is that the techniques themselves are not new new at all. It uses powerful, native techniques that have been around since FileMaker 7–like global keys and cross-joins–but it organizes them as a pattern\u00a0that we can describe, much like we can describe the Anchor-Buoy pattern. FileMaker Data Models: Extending Anchor-Buoy The Selector-Connector should be seen as\u00a0an extension of the currently predominant data model, Anchor-Buoy. Anchor-Buoy is arguably the most widely adopted FileMaker standard in the development community, and there are two very good reasons for that. It organizes the graph very clearly with a small set of rules It has a great name that is very visually descriptive. We want to make sure we don’t lose either of those things \u00a0if we’re going to tinker with the model. In general terms, Selector-Connector keeps the current Anchor-Buoy model but builds “on top of it.” We’re just going to “bend” its rules a little bit. A very basic interpretation of the Anchor-Buoy rules would be: All layouts must reference Anchor Table Occurrences Interacting with Buoys is only done from the context of their Anchor Anchor Table Occurrences\u00a0cannot be related to each other. By sticking to these rules, the Anchor-Buoy model forces us to be aware of context and it also limits the chance of us doing an operation out of context, like picking the wrong table occurrence for a portal; very important things in FileMaker and generally these benefits have outweighed the draw-backs of Anchor-Buoy, and that’s why it’s the standard. The Pop-Over Cometh As I mentioned above, there’s nothing technically new to the Selector-Connector model. So what\u00a0changed to start us down this road? For me, it was the introduction of the Pop-Over in FileMaker 13. Here was a great new object that would be a light weight alternative to pop-up windows and dialogs.<\/p>\n","protected":false},"author":3,"featured_media":8574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[7,30],"class_list":["post-8551","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-filemaker-13","tag-seedcode-complete"],"yoast_head":"\nFileMaker Data Modeling, Selector-Connector & Anchor-Buoy<\/title>\n<meta name=\"description\" content=\"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FileMaker Data Modeling, Selector-Connector & Anchor-Buoy\" \/>\n<meta property=\"og:description\" content=\"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\" \/>\n<meta property=\"og:site_name\" content=\"SeedCode\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/seedcoder\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-24T13:20:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-08T16:31:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"109\" \/>\n\t<meta property=\"og:image:height\" content=\"110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"jasonchryoung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dayback\" \/>\n<meta name=\"twitter:site\" content=\"@dayback\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jasonchryoung\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\"},\"author\":{\"name\":\"jasonchryoung\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd\"},\"headline\":\"FileMaker Data Modeling with Selector Connector\",\"datePublished\":\"2015-02-24T13:20:02+00:00\",\"dateModified\":\"2023-08-08T16:31:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\"},\"wordCount\":2155,\"commentCount\":36,\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png\",\"keywords\":[\"FileMaker 13\",\"SeedCode Complete\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\",\"url\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\",\"name\":\"FileMaker Data Modeling, Selector-Connector & Anchor-Buoy\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png\",\"datePublished\":\"2015-02-24T13:20:02+00:00\",\"dateModified\":\"2023-08-08T16:31:40+00:00\",\"description\":\"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.\",\"breadcrumb\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png\",\"width\":109,\"height\":110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seedcode.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FileMaker Data Modeling with Selector Connector\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seedcode.com\/#website\",\"url\":\"https:\/\/seedcode.com\/\",\"name\":\"SeedCode\",\"description\":\"Build the Software You've Always Wanted\",\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seedcode.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/seedcode.com\/#organization\",\"name\":\"SeedCode\",\"url\":\"https:\/\/seedcode.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"width\":595,\"height\":189,\"caption\":\"SeedCode\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/seedcoder\",\"https:\/\/x.com\/dayback\",\"https:\/\/www.linkedin.com\/company\/seedcode\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd\",\"name\":\"jasonchryoung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"jasonchryoung\"},\"url\":\"https:\/\/seedcode.com\/author\/jasonchryoung\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FileMaker Data Modeling, Selector-Connector & Anchor-Buoy","description":"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/","og_locale":"en_US","og_type":"article","og_title":"FileMaker Data Modeling, Selector-Connector & Anchor-Buoy","og_description":"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.","og_url":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/","og_site_name":"SeedCode","article_publisher":"https:\/\/www.facebook.com\/seedcoder","article_published_time":"2015-02-24T13:20:02+00:00","article_modified_time":"2023-08-08T16:31:40+00:00","og_image":[{"width":109,"height":110,"url":"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png","type":"image\/png"}],"author":"jasonchryoung","twitter_card":"summary_large_image","twitter_creator":"@dayback","twitter_site":"@dayback","twitter_misc":{"Written by":"jasonchryoung","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#article","isPartOf":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/"},"author":{"name":"jasonchryoung","@id":"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd"},"headline":"FileMaker Data Modeling with Selector Connector","datePublished":"2015-02-24T13:20:02+00:00","dateModified":"2023-08-08T16:31:40+00:00","mainEntityOfPage":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/"},"wordCount":2155,"commentCount":36,"publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"image":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png","keywords":["FileMaker 13","SeedCode Complete"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/","url":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/","name":"FileMaker Data Modeling, Selector-Connector & Anchor-Buoy","isPartOf":{"@id":"https:\/\/seedcode.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage"},"image":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png","datePublished":"2015-02-24T13:20:02+00:00","dateModified":"2023-08-08T16:31:40+00:00","description":"A refinement to the Anchor-Buoy pattern for FileMaker's relationship graph, the Selector-Connector data model may offer more portability & less redundancy.","breadcrumb":{"@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#primaryimage","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2015\/02\/ab1.png","width":109,"height":110},{"@type":"BreadcrumbList","@id":"https:\/\/seedcode.com\/filemaker-data-modeling-with-selector-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seedcode.com\/"},{"@type":"ListItem","position":2,"name":"FileMaker Data Modeling with Selector Connector"}]},{"@type":"WebSite","@id":"https:\/\/seedcode.com\/#website","url":"https:\/\/seedcode.com\/","name":"SeedCode","description":"Build the Software You've Always Wanted","publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seedcode.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/seedcode.com\/#organization","name":"SeedCode","url":"https:\/\/seedcode.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","width":595,"height":189,"caption":"SeedCode"},"image":{"@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/seedcoder","https:\/\/x.com\/dayback","https:\/\/www.linkedin.com\/company\/seedcode\/"]},{"@type":"Person","@id":"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd","name":"jasonchryoung","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"jasonchryoung"},"url":"https:\/\/seedcode.com\/author\/jasonchryoung\/"}]}},"_links":{"self":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/8551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/comments?post=8551"}],"version-history":[{"count":0,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/8551\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media\/8574"}],"wp:attachment":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media?parent=8551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/categories?post=8551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/tags?post=8551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}