Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


search in portal

Posted on 2006-03-27
Medium Priority
Last Modified: 2010-04-27
do you know how to search in portal?
i get wrong data after searching in portal.
Question by:Hiroyuki Tamura
LVL 19

Accepted Solution

billmercer earned 300 total points
ID: 16304393
If you do a Find for records based on entering criteria in a portal, the records returned will be the ones in the main layout that relate to the criteria in the portal.

For example, if you have a database of animals, like cows, horses, and goats, and a portal showing what foods they eat, if you do a Find for "hay" in the portal, the found set will include all animals that have "hay" as one of their foods, even if they also eat other foods. The portal for each record will still show all the related records for that animal.

If you want to filter or restrict which related records appear, you need to use a different approach.
You can either modify the portal relationship so that it shows only the desired results, or you can use a script that switches to a separate layout and displays only the desired records that way.

LVL 28

Assisted Solution

lesouef earned 200 total points
ID: 16308324
Another approach maybe?
When in find mode, no record is active, therefore, at that very moment, the relationship is disabled; so there is no more filtering done by the portal, it is a simple pass through for all records of the related table.
The easiest way for me is:
- to go to related records in a another window using a layout related to the sub table, display "only related records/match current record only" and then do a find here using "constrain found set", to narrow down the record set with the find criteria.
But doing the find directly in the sub table is far easier in most situations, simply using 2 fields, the one you need + the ID allowing to isolate the parent record.

Author Comment

by:Hiroyuki Tamura
ID: 16426946
thank you, billmercer and lesouef:)

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses

564 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