How can i set a default value in a linked field (dropdown)?

Hi to all,
I would like to know how to set a default value in a field linked to another table (The linked field is set as a dropdown). I want to get the field value “Last name and first name” according to current user . In the queried table there is also an “email” field by which the record could be filtered.

Thanks for any advice