search in portal

Posted on 2006-03-27
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

    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

    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
    thank you, billmercer and lesouef:)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now