Help with security related script trigger
I'm a bit of a FM newbie so please be patient with me..
I'm developing a supplier contact information database that will be externally to suppliers via IWP to update their own contact details.
Obviously the supplier should only be able to access their own record and no-one elses.
I have setup the priviledge set so that each supplier can only view and edit their own record.
I need a script trigger (OnFirstWindowOpen?) that will direct the supplier (who has their own login account) to go straight to their record. We have over a thousand records so the supplier really needs to be able to immediately view their own record rather than have to find it.
Any help would be appreciated!