Business Rule to replicate key user table from sys user table

[Kumar_a43]

I am trying to create new Business rule where key user table fields like company, status and country details will get those data from sys user table.

Can you suggest me the condition and script for that.

[AnirudhKumar]

Shouldn't it be the other way round?

Take the Company table for example, it needs data before it can be selected on a new user form.

[Sandeep Rajput]

@Kumar_a43 Company and Country are part of foundation data and they should be populated independently not on the basis of the user record. The user records should refer to these foundation data and not the other way around. 

[Kumar_a43]

We have a custom table name which is "Key User" and some fields like company, location and status should refer the value from sys user table.