Showing first portal record
I have a layout based on a table (Schools) with a portal to a self join table. The schools portal goes to related records in the Seniors table. The schools portal is sorted by School Name. When the layout is opened the related records are from the first school in the table not the first school in the portal. As I click on each school they show the correct related records. I would like the default school to be the first school in the portal. I've tried to sort the table in a script trigger that opens the layout but that didn't work. I've tried to Go to Portal row First but it goes the the first record in the related portal.
I must be missing something simple but can't figure out what that is. Any help would be greatly appreciated.