Merge Field within Portal
I am using FMP13 Adv. to organize event planning (entertainment touring specifically). I have a portal that shows only one related record that is derived through a relationship between duplicate tables. The operators in the relationship allow me to "see one and only one day ahead." The fields in the portal are "Address 1", "Address 2", "City", "State", "Zip" and so on. I distribute the information on 8 1/2 x 11, so space is limited.
I would like to use a merge field within the portal to save space, e.g. <<City, ST Zip>>, but when I add the merge field to the portal all that shows is the Merge Field information rather than the data, i.e <<City, ST Zip>> rather than <<Nashville, TN 37203>>. The information shows as expected when individual text fields are used. I feel comfortable typing a merge field into a layout, but I've intentionally used the menu commands (Insert > Merge Field…) to make sure I am selecting data from the correct table and field.
Is this a limitation to FMP13?
Thanks for any light you can shed!!!