IF Condition only reads the first record from another portal
More specifically, it references the first related record from the related table. If your portal is unsorted and unfiltered that will be the first record shown in a portal based on the same relationship, but with other portal options specified, the first related record might not appear in the first portal row.
I've read your description of your layouts and portals but this does not tell me what tables your have and how they are linked in relationships. You appear to have a portal to a table named Local_Sales and another to a table named National_Sales and you describe them as being placed on two different layouts. But on what table are the Layouts based? This is specified in the "Show Records From" drop down in Layout Setup... And how is the layout's table linked in a relationship to the portal's table? And is it possible that you have one layout with two portals? Or have you given the tables for the layouts and not specified what table(s) are used for the portals?
And most important: If you don't want to refer to the first related record each time, to what record do you want to refer? (How do you know which of the related records is the correct one to reference?)
Thanks Phil, I got it now to work properly. You're right about the relationship, I forgot to check the relationship. I got the idea from one of your answer from one of my posts here, regarding the relationships of different tables and how to relate it properly. Thanks again Phil!