Can't really say as we don't have a clear picture of the structure here. Same tables as the first portal? Different tables?
Yes same tables but I went into manage database the relationships tab and duplicated the Jointable and DBE table.
This gave me Jointable_2 and DBE_2
If they are the same tables, why do you need to duplicate the table occurrences? What's the key difference between the two portals? I know you've said it's to " mark final payment amount", but that doesn't tell me very much.
I'm leaning toward a portal filter for this on the second portal, but am not sure it will work for you or not.
your right no reason for the 2nd one. thinking to hard. thanks