Select One Portal Row Field Data

Posted on 2006-04-09
Last Modified: 2010-04-27
FMP 8 Advanced

I have a Contacts table. Related to it I have an Address table as well as three other tables which use Portals. One of the Portals is called Work History. I want your "address" entered automatically to the Work History Portal as well as the mailing envelope. An example:

Contacts Table

I enter your name in the the first two fields.

Addresses Table (Portal)

Next I enter your address for when you are in Connecticut
Next I enter your address for when you are in Florida

Work History (Portal)

Here is where I enter the support work that I peformed for you. If you called from Florida I want the State field for Florida entered (FL); if you called from Connecticut I want the state field for Conecticut entered (CT).

I have marked the address row in the portal with a flag field. How do I tell FileMaker to use the state field from the row marked with an "X" for the state field in the work history?

The information will be used when I print your envelope - use the address of the Portal row that has the "X".

Thanking you in advance,

Question by:BurtonCohen
    LVL 28

    Expert Comment

    you need a relationship in between the work history and the address tables.
    and this relationship should be based on contactID field AND the flag field. This assumes you have a global field filled with "X" in the work history table too, to link it to the address table.

    Author Comment

    Maybe I am missing something.

    When I create the "X" global field in the Address table and then add it to my address portal, when selected it marks ALL rows with an "X" not just the row I wish to designate as the "billable/ mailing" address.

    I have not yet created the additional table occurrence.

    What am I doing wrong?


    LVL 28

    Expert Comment

    no, the global X must in work history.
    in the address table, this is regular field, not a global one

    Author Comment

    Thanks for the fast response.

    I am dumb. I have created the global field in work history.

    Where / how do I create the relation? Table Occurrence? Value List?

    Remember I want the field in history to be filled with  the address that has an"X".

    Thanks again,

    LVL 28

    Accepted Solution

    define database/relationships/ second icon from the left.
    should be:
    work_history::globalmark <> address::mark
    work_history::contactID <> address:contactID
    then you'll be able to get the adress from the marked address line into the work history layout, or copy it to a work history field if you need to keep it separate from the address table (can use in this case, a looked up value)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 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

    21 Experts available now in Live!

    Get 1:1 Help Now