Filemaker Portal Limit Record Display by date.

Posted on 2013-09-09
Medium Priority
Last Modified: 2013-12-03
I have a database with a customer and orders table. I have a portal based on the customer layout that displays
the customers orders. The portal currently has 10 rows. I want to be able to just display the most recent 10 orders
the customer made based on the order creation date. I know I can sort the portal by the orders creation date, but that
will include all of the orders, although they may not be visible to the user. I want to just only include the latest
10 orders for the customer. I want to be able to do this via a relationship. Both of my tables have include the customer_ID
and a creation_date.

Is this possible?
Question by:PachecoPrimo
1 Comment
LVL 25

Accepted Solution

Will Loving earned 2000 total points
ID: 39477491
Set the relationship to sort by Creation Date, Descending rather than ascending. Then, in Layout Mode, double-click on the Portal to bring up the Portal Setup dialog. In the dialog you have the option to designate which portal records are visible based on order. Simply set it to 1-10 and the portal will only show the 10 latest records.

Portal Setup Dialog

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question