Community Forums

    1. FileMaker Pro 14 General Discussion

      General discussions that don't fit in to any other topic centric forum.

      33,937
      posts
    2. FileMaker WebDirect

      Present your database online with WebDirect. And support external clients customers on Desktop or even Mobile Tablet Browsers (iPad / Android)

      678
      posts
    3. FileMaker Go for iPhone & iPad

      Mobilize your solution. Discussions on designing your solution for IOS. 

      1,964
      posts
    4. FileMaker Interface Features

      Menu Bars, Button Icons (SGV), Place Holder Text, Navigation Parts, Color Palette, Popovers, Slide Control, Swipe Gestures, iOS Keyboards

      63,149
      posts
    5. FileMaker Inc.   (491 visits to this link)

      Official product specifications and information.

    1. Community Articles, Tips, & Techniques

      Member contributions including articles, tips, tricks & techniques. Please provide links to previously posted threads, and demo or sample files & open source solutions. Discussion and dialog for implementation and development.

      4,157
      posts
    2. FileMaker Marketplace Discussions

      Discussions on submitted files from members.

      119
      posts
    3. Blog Posts

      Blog post from our member's blogs...

      501
      posts
    4. Function of the Day

      Get to learn FileMaker daily. This forum will feature a FileMaker function it's definition, options & parameters. It will feature a few examples. We ask you to continue sharing your examples of how you use this function.

      504
      posts
    5. Question & Answer Forum

      testing Q&A forum format...

      10
      posts
    6. Custom Functions

      General Discussions on developing custom functions with FileMaker Advanced

      2,679
      posts
    1. Security Concepts

      Accounts & Privileges & Passwords. Information you need to know about security concepts.

      7,541
      posts
    2. Intellectual Property

      Discussions in protecting all your hard work.

      374
      posts
    1. FileMaker 14 Server

      Deploy, Configure, Manage a FileMaker Server

      126
      posts
    2. FileMaker 14 Stand by Server Deployment

      For mission critical environments where you must maintain uptime on your primary FileMaker Server. Learn how to deploy and manage a Standby server. 

      19
      posts
    3. FileMaker Server 13

      Deploy, Configure, Manage a FileMaker Pro Server

      1,487
      posts
    4. FileMaker Server 13   (2,786 visits to this link)

    5. FileMaker Custom SSL Certificates

      Discussions and instructions for securing your communications with Custom SSL Certificates from third party Certificate Authorities.

      64
      posts
    6. External Server Authentication

      Configuring and administration of FM Server using Active Directory & Open Directory

      975
      posts
    7. 22,840
      posts
    1. Managing Scripts

      Writing efficient automated tasks with scripts, managing complex business logic, passing parameters, debugging and error trapping.

      53,052
      posts
    2. Calculation Engine (Define Fields)

      Field Types, Field Options, and those wonderful Calculation Functions!

      66,017
      posts
    3. FileMaker Query Language or FQL

      Discussions about Execute SQL function, and SQL syntax for your your database logic.

      926
      posts
    4. Relationships

      Creating and developing relationships, creating children, avoiding orphans.

      29,898
      posts
    5. Charting

      Adding charting to FileMaker Pro

      727
      posts
    6. Remote Container Fields

      Discussions regarding remote container fields for FM12 and FMS12

      417
      posts
    7. Finding & Searching

      Using the find mode and or relationships to search or find record sets.

      16,168
      posts
    8. Importing & Exporting

      Getting data in and out of FileMaker.

      21,971
      posts
    9. External Data Sources

      Implementing and utilizing External Data (SQL) Sources (ESS) in your solution.

      4,400
      posts
    10. Advanced & Developer Features

      Runtimes, Design Report, etc.

      6,643
      posts
    11. Reports, Printing & Publication

      You got the data in now you need it out without mowing down a forest!

      11,825
      posts
    12. Custom Web Publishing

      Interfacing FileMaker as a data source for the web. 

      30,490
      posts
    1. The Left Brain

      Complex calculations, advanced scripting and other mind boggling topics.

      9,876
      posts
    2. Upgrading & Migration

      Transition, upgrade, migrate your legacy solutions.

      2,620
      posts
    3. Data Analysis

      Discussions about statistics, business intelligence, data visualization, machine learning, or whatever other flavor of data analysis you want.

      63
      posts
    4. The Separation Model

      Learn & discuss the pros and cons of developing & maintaining the separation of data & schema.

      1,277
      posts
    5. Development Standards

      Explore "standards" adopted by developers. Implementation and documentation. Don't start from scratch.

      862
      posts
    6. Relational Database Theory

      Discussions on what makes a database 'tick'. Non-tech background on database design.

      1,199
      posts
    7. Damaged / Corrupt File Problems

      discussions on file related issues and procedures for recovering your files.

      818
      posts
    8. OS Level Database Automation

      Save steps learn how to automate your solution.

      4,727
      posts
    9. 4,047
      posts
    1. 360 Works General Support

      general question for product & service support.

      1,052
      posts
    2. MirrorSync by 360Works

      Discussions about MirrorSync, a FileMaker synchronization tool that links FileMaker Server to FileMaker Go and FileMaker Pro

      869
      posts
    3. SuperContainer by 360 Works

      Discussions on how to implement and deploy SuperContainer by 360Works.

      2,990
      posts
    4. ScriptMaster by 360 Works

      Discussions regarding ScriptMaster plugin allowing you to run Java code directly within FileMaker. Share, compare and discuss your code.

      3,477
      posts
    5. FTPeek by 360 Works

      FTPeek is a Universal Binary FTP Plugin for FileMaker that supports encrypted transfers, scheduled server operation, and uploads/downloads directly to FileMaker text and container fields.

      321
      posts
    6. 360Works Email Plugin

      Discussions on how to implement and deploy Email Plugin by 360Works.

      686
      posts
    7. DocuBin by 360 Works

      360Works DocuBin is a full-featured document management solution created with FileMaker. Please use this discussion area to post any questions and suggestions you have.

      134
      posts
    8. Zulu – FileMaker, iCal & Google Calendar.

      Discussions and support for Zulu, which syncs FileMaker to iCal and Google Calendar.

      90
      posts
    1. FM Starting Point - General Discussions

      Discussions about the FREE FileMaker template.

      278
      posts
    2. FM Starting Point - Bugs

      Report any problems that you experience with FM Starting Point here.

      35
      posts
    1. 717
      posts
    2. Monkey Bread Software (MBS Plugin)

      This plugin by Monkey Bread Software is an essential tool for many development projects. Since it has so many options and features this discussion forum is a way to share your experiences, tips, and suggestions. 

      1
      post
    3. 2,979
      posts
    4. 837
      posts
    5. Accounting Solutions

      FileMaker accounting solutions & 3rd party integration.
      (Quicken / QuickBooks)

      223
      posts
    1. Professional FileMaker Training

      Find out about professional training courses across the globe from a variety of instructors. Discuss training courses and find the best course to suit your needs. Prepare yourself for certification.

      1,279
      posts
    2. ISO FileMaker Magazine

      Discussions and suggestions with the Editor of FileMaker Magazine.

      302
      posts
    3. User Group Central - Sponsored by FMPug.com

      News and Announcements regarding local user and developer groups. Looking to start or join user group? FMPug can help. Come for the FileMaker stay for the Perks!

      468
      posts
    4. Making A Living

      Is FileMaker development your core business? Discuss the business of being in business or relating to the dynamics of working as an in house developer or in the educational sector.

      1,052
      posts
    5. Shrink Wrap Solution Developers

      Discussions for developers producing and distributing shrink wrap solutions.

      199
      posts
    6. Jr. FileMaker Developers' Forum

      Discussions becoming or working as a Junior Developer in the FileMaker Community.

      20
      posts
    7. Third Party Integration

      Beyond FileMaker

      • No posts here yet
    1. FileMaker Product & Service Announcements

      Want to tell the world about your FileMaker related product or service? Post your press, releases and highlights are welcome...

      1,149
      posts
    2. Services for Hire

      Spotlight of our member's products & services.
      Announce your availability to take on that next big project.

      41
      posts
    3. Services Wanted

      Take on a job you just can't handle alone. Post your "Help Wanted" ads here.

      1,207
      posts
    4. Solutions Wanted

      Searching for that ready made solution, perhaps someone else can point you in the right direction

      1,009
      posts
    1. Member Lounge

      Off topic community chatter. Mingle and get to know your fellow members perhaps meet a friend.

      1,921
      posts
    2. Wants & Wishes

      Discuss features that you wish to see in the next version of FileMaker products.

      1,517
      posts
    3. FileMaker Developers Conference

      Discussing the annual Devcon, including travel arrangements and associated events.
      Need to find a roommate?

      131
      posts
    1. FM Forums Feedback & Site News

      News and Feedback regarding this site.
      NOT FOR FILEMAKER SUPPORT

      930
      posts
  • Topics

  • Posts

    • The correct ERD
      By comment · Posted
      I don't follow your description. Why two more tables? Based on your description, all you need is: Fleets -< Boats -< Ownerships >- Owners If you place a portal to Owners on a layout of Fleets, you will see all owners of any boat in that fleet.   You need to tell us what that third table tracks, and how is it related to the other tables (esp. the Fleets table).  
    • The correct ERD
      By Enigma20xx · Posted
      Thinking of the twist, I think is more a turn than a twist. If I'm not wrong the new perspective goes to a conditional value list based on hierarchy. Sorry about that.
    • The correct ERD
      By Enigma20xx · Posted
      Another twist. Now we have a boat that can be owned by one or more persons. A VL based on a relationship can filter only the owners to be used in third tables. Adding two more tables at the left side of the ERD. Let's say: A FLEET table and a JOIN table (fleet/proterties-boats-). Placing the ID of a fleet in a third table, how can owners of any boat of that fleet be shown?
    • Tunneling Relationship to find unrelated records?
      By MSPJ · Posted
      Ok - so I got this to work perfectly in the Data Viewer - used nested ExecuteSQL statements.   The goal is to use it as a selection criterion, sitting on a claim, looking at a portal of visits. To do this, I set the portal filter to Visit ID = big long ExecuteSQL expression. This works fine on one particular claim, but when I switch to a different claim, it no longer works, even though the Execute SQL statement in the data viewer continues to work.  In other words, the Portal Filter seems to be record-context sensitive, while the Execute SQL code in data viewer, does not have that same context sensitivity.  Does this make sense?  
    • Almost There but still returning duplicates.
      By Peter Barfield · Posted
      Barbara, you are a legend. That has certainly done the trick. it's amazing what one little letter can do. It was actually duplicated in the host file as well so it must have been my brain thinking multiple payloads when creating the table occurrence.Who Knows? You know I never would have found that in a million years. Tried a sync and works beautifully. Thanks again Barbara most appreciated.
  • Popular Contributors