Displaying portal records according to 'accountname'
I have a "dashboard" layout that I have a portl that shows records from a 'workorders' table. I am wanting to display only those 'workorder' records that are assigned to the person that is logged in.
Each record is assigned to a Team Member. I have a 'TeamMember' table that has a field that reflects their 'accountname'. I have a script that runs on opening of the file that will assign the account name as a global variable. Am I on the right track? Does the global variable stay the same if more than one user is logged in? Or will it be particular to each session?
Not sure how to tie it all into that portal.