Jump to content

Search the Community

Showing results for tags 'joins'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • 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
    • oAuth and 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)
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
    • Product Ideas
  • 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
  • FileMaker Vendors
    • FM Starting Point - By Richard Carlton Consulting
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • Comm-Unity Networking Systems (CNS)
    • SmartPill PHP Edition
    • FileMaker Plug-Ins
    • Accounting Solutions
    • FM Easy Suite Framework
  • FileMaker Training Resources
    • Professional FileMaker Training
    • ISO FileMaker Magazine
    • FileMaker Developer Conference
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

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

Found 7 results

  1. We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary. How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.
  2. We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql database and a table identical to that of that of the secondary. How do sync the two seperate databases in a single configuration? Or is that even possible. I could see that I could generate two seperate configurations; and perhaps split the mobile version into two seperate FileMaker files; i'm just wondering if there is a smarter way to go about what I need to achieve.
  3. Hey gang, Trying to figure something for a fellow lister. I am tring to run a query in FileMaker using ExecuteSQL() that works perfectly when I run a similar query in a normal SQL editor: SELECT p.pk_ProductID, p.Description, SUM(i.Quantity) AS sQTY FROM invoice_invoicelines_Product p JOIN invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND i.fk_InvoiceID IN (1,2,3) WHERE p.pk_ProductID IN (1,2,3) GROUP BY p.pk_ProductID It produces a "?" (which is very informative). I guess need to know if this is too much for FileMaker's SQL engine or if FileMaker is going to force me to use something that is not tradition SQL protocol/syntax. Any feedback would be appreciated.
  4. Hi - I'm trying to do something that seems like it should be doable, but I can't quite figure out how to do it - I've thought about using relationships and SQL, but neither quite gets me there. I have 4 tables: Visits, VisitClaims, Claims, Account. The relationship between Visits and Claims is many to many, thus the join. When I'm standing on the Claims table , I can easily see all the visits that are assigned to that Claim - simple. If I'm standing on Account, I can see all the visits that have been assigned to claims using that account What I'm trying to do is stand on Claims, and find Visits that have NOT been assigned to claims using the same account as the current claim. In other words, when I go to create a claim, I don't want to see visits that have previously been assigned to claims associated with the same account as the current claim. I'm sure I could do this with some kind of multi-step find -- Find the set of visits that were assigned and then omit those from the full set - but I'm not sure how to create a portal filtered by that definition. I could do a script that runs the find, but I'd have to rerun it every time something changes. That's a possibility, but I'd prefer not to do it that way. It seems like there must be a more straightforward way to do this... Thanks!
  5. Hi - I have a runtime solution that I will be upgrading. The new version will have several many to many relationships where previously there were many to one. So I'll need to populate the new Join tables with data to correspond to the previously existing instances in the earlier version. I'm thinking this must be a fairly common thing to do as one realizes the need for more complex relationships and additional entities. Is there a well-known or standard way to import the old data into the new configuration? Thanks, Michael
  6. Many-to-Many Challenge

    I have been out of the Filemaker Pro arena for the past 8 years. I’m currently working to bring myself up to speed on FMP 11 Advance and have run into an issue and I can't seem to get my arms around a solution. First let me start by identifying my primary tables, primary, foreign and match key fields, and the current database schema: tblCONTACTS (fields: [pkCONID] primary, [fkHHID] foreign, [kContact_Type] match key and other fields) tblHOUSEHOLD (fields: [pkHHID] primary and a bunch of address fields) tblHOUSEHOLD_JOIN (fields: [fkCONID] and [fkHHID]) I have a join between tblCONTACTS::pkCONID on the one side and tblHOUSEHOLD::fkCONID on the many; likewise, I have a join between tblHOUSEHOLD::pkHHID on the one side to tblHOUSEHOLD_JOIN on the many. The reason I used the join table is because the Contacts who are labled as "Child" from the [kContact_Type] field can belong in several different households (mom and step-dad, dad and step-mother, etc). In order to get a one-to-many relationship for this specific cohort I added a join table between tblHOUSEHOLD and tblCONTACTS. The CONTACTS table is just as you would expect, a table that contains information relevant to all of the people in the database. The HOUSEHOLD table contains all of the addresses of the people in the CONTACTS table. The field [kContact_Type] in the CONTACTS table is used to distinguish between Children (<18 with no children of their own), and Participants (anyone else). [kContact_Type] field contents are drawn from a value list containing two words, "Child" or "Participant". My ultimate goal: To have the ability to report on Contact activity as a group within the same household [HHID], individually by [kContact_Type]= "Child" or "Participant", and the really tricky part for me… I need to be able to look at these two groups by their roles as they relate to one another: One mom can have many Children, one [Child] will have at least one, morely likely two or more[Participants] a/k/a parents. And not all Participants are parents (some won't have any children). I assume I need a seperate table for these relationship roles but I can't seem to work out how that would work. I tried creating a table occurance based on CONTACTS in a self-join relationship hoping I could link by both the CONID and the [kContact_Type] of "Child" or "Participant"... but naturally that didn't work and I was looking at a mirror image of the main table. I tried seperating the contents of "Child" and "Participant" into two different fields and then creating a self-join... but I still got the mirror image since the join didn't distingish between fields that had null values. Any help you can give me on how I might set this up to work would be greatly appreciated.
  7. Hello, From a design point of view, in a set of related tables within a database: is it recommended or optymal to have multiple join files or a single one. For instance, given: teachers students classes teachers_exams courses We could have: teachers JOIN1 classes students JOIN1 classes teachers JOIN1 teachers_exams students JOIN1 courses teachers JOIN1 courses or teachers JOIN1 classes students JOIN1 classes teachers JOIN2 teachers_exams students JOIN2 courses teachers JOIN2 courses Thanks
×

Important Information

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