Jump to content

Search the Community

Showing results for tags 'related record'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 6 results

  1. Filtering by Related Record

    So I have two tables. I'm going to be very specific and use very general terms to make sure there isn't any confusion, so thanks ahead of time for bearing with me since this description might seem a bit monotonous. Table A Name_fk Item Number | Table B Name_pk Team I put a relationship between Name_fk and Name_pk. Name_pk is a list of names and what team they are. Name_pk is filled with entirely unique values, so you know John Smith is on Team Blue there is only one record with "John Smith" in the Name_pk field and that record has "Team Blue" in the Team field. Now Table A will have a lot of repeat items under Name_fk. There will be ten rows with John Doe in them, ten Jane Doe rows, ten Joe Doe rows, and ten Jess Doe rows. Joe and Jane are on Team Green according to Table B, and Jess is on Team Blue with John. In the relationships section of the Database Manager, I have linked Name_pk and Name_fk. I need to be able to search for Team Blue, and only have John and Jess's item numbers show up, or search Team Green and have only Jane and Joe's Item Numbers show up. So far I have been unable to get this to work in my current solution, although a test solution works fine.
  2. Hi everyone, I've run into a problem that I'm having difficulty solving and am hoping that someone here can help. I'm working on a database that contains information about collared and released cheetahs: info such as location points (aka 'Fixes'), kills made by the animal, captures/releases of that animal, supplemental feedings, etc. One of the tables is titled 'Tracking Sessions' and receives a new record anytime that someone goes out to track (find) that animal in the field. I have a layout for Tracking Sessions that contains a portal to a table titled 'Tracking Notes' which contains all of the time-specific details that occur during any given tracking session. Each record within 'Tracking Notes' has a field called 'Visual' which is 'yes' (true) if the animal is physically seen during the time of this record and 'no' (false) if the animal is not seen. I'm not even sure it's possible, but what I'm struggling with is making every 'Tracking Notes' record that is true for 'Visual' to automatically be added to another table labeled 'Fix Data' and be automatically updated if the record is updated in the 'Tracking Notes' table via the portal in the 'Tracking Sessions' layout. I've tried using the 'magic key' method (which I've never used before and obviously don't fully understand) and records are created but it doesn't seem to work all the time and it doesn't update existing records when changes are made, it just creates duplicates with the updated info. If anyone has any ideas on how to accomplish what it is I'm trying to do, I'd really appreciate it. I've included an image here of my relationship graph and the relevant tables highlighted in varying colours. As you can see, I've created two new occurrences of 'Fix Data' so far. If I need to provide any further details or clarify anything please let me know.... I'm quite new to Filemaker. Thanks! Eli Walker
  3. This has been stumping me for a long time, and I am sure I am overlooking something incredibly simple. Hopefully I can explain this well enough.  I have a relationship between several tables (see example ).  Whenever a record is created in any of the three related tables (Table1, Table2, Table3), I want a new ExtraData record to be created with the same key as the record in the related table. I also want the userValue to be set to the value of a global variable I have $$curUserValue, only if the ExtraData::userValue is empty. If the ExtraData record exists, the ExtraData::userValue changes, AND the key changes, the ExtraData::userValue should just be updated.  Right now I have an onRecordCommit script on the three tables' layouts that creates a new ExtraData record with the current record's key, if such a record does not already exist. It also sets ExtraData::userValue = $$curUserValue. This works fine, but if the related table record's key changes, then a new ExtraData record is created with the new key and $$curUserValue. The problem here is if the ExtraData::userValue field has changed, along with the key, it gets overwritten with the original $$curUserValue.* I want to keep it the same as what it was before the key change.  There must be a much easier way to accomplish this, but the solutions escapes me. Any ideas?   *I am NOT concerned with the orphan records this creates, as I have a script to clean those up.
  4. Guys, The old guy trying to learn new tricks.. I am trying to devise a little help for a friend. The problem : A layout with a map pasted on it. On this map I need to set buttons with names, and want to see related record windows popup when I click the button. The layout is in the same database the record I am looking to visualize. I tried several way, but I only get the first record in the list.. I may not be smart enough for the task..! New to FMP 12, and not really familiar with triggers capabilities...!! However I am wondering how could I do to have the button name taken into consideration by FM and popup the window the correct record. Thanks in advance
  5. Hi, I need help trying to create an elegant solution to this problem. I need to do a "CountIf" type summary, counting all related records to the current one (which are also shown in a portal). I have an Assignments table (each record has a unique AsnID) and an Individual Submission table with many records (each tied to the Assignment record through the AsnID). A one:many relationship. The important field here is that each Individual Submission has a field "Rating" that only allows "A", "B" or "C" values. I'm sure you can see where this is going. Is there are way that I can have a calculation field in "Assignments" that will count how many "A"s there are in all the related records' "Rating" field? (I'll need three of them, one to count As, one to count Bs, and one to count Cs, but I can work that out if someone can show me how to do one of them). In the main layout in which I'll be using this information, there's also a portal showing all the related records, so if it uses the portal to do this calculation, that's fine, but I'm sure it's possible without it. This seems like a pretty simple thing to do, but I can't work it out and I can't find the answer through Google either.
  6. I've got a field on Layout A (from Table A) that displays a values from a value list in a dropdown. The value list displays values from Table B which is a personnel table. So the field on Layout A displays "Last & First" when the dropdown is clicked in browse mode. I would like to set up a button action to go to the related record in the personnel layout but something isn't set up right, I'm guessing in the relation between the tables. How should the relationship be set up to get the button action to work to go to the related record in a different layout/table? The field the button action is on is "Safety Clearance:Primary Authorized Employee". The value list inputs values from "Personnel:Last". And I have a relationship between the tables established as Safety Clearance:Primary Authorized Employee = Personnel:Last.

Important Information

By using this site, you agree to our Terms of Use.