I want to take the current logged in user ($User), and compare that to my userTable, find the users record, and take the first and last name fields and plunk them in as the default value for a field in the current table.
Is that possible? If so, how?
let say that 'people' is your usertable:
$WBF{$x,'d'} = '$xx=&FLD(people,$User,lastName)." ".&FLD(people,$User,firstName);"$xx"';
see also: http://www.ddatabase.com/man.htm
claudio