AccountName problem/help

[skumancer]

Ok, so here is my problem.

I have a IWP accessed database, a username is needed to enter the DB and make a new error report (its for a company that need to report errors). When the create a new report (read:record), I want the script to go and find the AccountName in another table, then bring the phone number and other details to the current record. How could I acomplish this using the AccountName they input when they login?

Thanks for the help!!