Select One Portal Row Field Data

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,

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
BurtonCohenAuthor Commented:
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?


no, the global X must in work history.
in the address table, this is regular field, not a global one
BurtonCohenAuthor Commented:
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,

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)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.