Update Portal between records

[Duhigg]

Vendor~LocationFiltered|VendorID| is my selection portal. The user selects one of the listed related locations which sets the global z_gSelectedRowID to the locations ID. Which in turn, displays that location within the LocationSelected portal on the same layout.

Vendor~Location|VendorID| is the base table relationship.

My question is this, I want to display the first Location record of the Vendor to Location relationship within the LocationSelected portal when the user navigates between records. This would correctly lists the first location for the vendor, but also allows the user to select another location with the selction portal with it's respective relationships.

Right now I have a blank record that's displayed (based on the way my relationship is set up) until the user clicks on a relationship.

The relationship between Vendor~Location and Vendor~LocationSelected is:

Vendor~Location|VendorID| - Vendor~LocationSelected|VendorID|

-------------------------------------------------

z_gSelectedRowID = __kp_LocationID

AND _kf_VendorID = _kf_VendorID

Any ideas would be greatly appreciated,