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:
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,