What is one thing common between HR profile record and user table record

[Drishti]

Hi Community,

Can anyone help me in one thing that what is common between HR profile record and user table record.

The reason I am asking is that I have to update "Title" field in user table whenever "Position" field is being update in HR profile record. 

I had created BR on HR profile table which will run when Position field changes and taken the value of Position field ,now what next?

How should I proceed to update the "Title" field in user table because I am unable to find anything common between these two records from user table and HR profile table.

Please guide, Thanks in advance.

[Community Alums]

Hi @Drishti ,

 I don't think email would be repeated.

[John Zhang1]

It is better you can find out yourself for the following steps:

1) Right-click on field label (First Name) and then you see followings

Steps 2-click on Show-'frist_name' (variable name) to see the following screenshot.  You can see this is from user table

[Drishti]

@John Zhang1 

I am in search of Primary field, the fields which you have highlighted can have repeated value.

[manjusha_]

@Drishti user is a field which will give you sysid of the record ,sysid is unique for each record ,so you can use this field 

Thanks,

Manjusha Bangale