Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 2 of 2
  1. #1
    Forum Member
    Join Date
    Dec 2012
    Posts
    10
    Location
    New York City
    FileMaker Pro Software
    Filemaker 15
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    11-27-2017
    Local Date
    12-10-2017
    Local Time
    09:16 PM
    Last Active
    11-27-2017

    Records from 2 different tables in a portal via SQL

    Hey all,

    Here's an odd little question:

    Can I get records from 2 different tables to appear in the same portal via a SQL filter calculation?

    Obviously I'd need to have the different fields from each table in the portal and yes it's probably a kludge but I thought it the easiest solution for what I need to do.

    If the answer is yes, what would the SQL calculation look like?

    Thanks,

    -Mark

  2. #2
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    114
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    12-10-2017
    Local Date
    12-10-2017
    Local Time
    06:16 PM
    Last Active
    12-10-2017
    A virtual list is probably your best bet:

    http://mightydata.com/virtual-list-in-3-easy-steps/
    - John Mark Osborne
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16.
    http://www.philosophyoffilemaker.com/

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Linking records to those in another table via a portal
    By Spooch56 in forum FileMaker Pro 8.5
    Replies: 1
    Last Post: 07-16-2009, 09:28 AM
  2. Selecting related records of same table in a portal
    By collinarose in forum Portal & Relationships
    Replies: 2
    Last Post: 11-18-2008, 01:50 PM
  3. Portal to show certain records only from Events table?
    By RichGags in forum FileMaker Pro 9
    Replies: 4
    Last Post: 09-27-2008, 07:38 AM
  4. fields from two records in a table to a portal
    By kensje in forum Portal & Relationships
    Replies: 4
    Last Post: 12-08-2005, 03:09 PM
  5. Portal records, stacked, join table?
    By GeoMcK in forum FileMaker Pro Versions 5 & 6
    Replies: 2
    Last Post: 07-31-2004, 07:53 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 43,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.