Auto populate field value

[Raji15]

Hi,

I have a variable named Business line. In user record every user has minimum 2 to maximum 8 organization levels. For example: some user have values till organization 8 level filed and some have till 4,5,6 etc.. So, in the variable named Business line, I want to populate the lowest level of the organization which the requested by user has in their user record. Its tricky and I dont know how to do that. Can anyone help please?

[Badrinarayan]

 If you want to populate the lowest level of the organization which the requested by user has in their user record. Is there any field in organization table which has user and their level i.e., 1,2,3,...etc ?

[Raji15]

The organization level of each user is mentioned in user record only.

[Mani A]

@Raji15 

 correct  me if i'm wrong

you have reference type field (business line) which refer to organization table.

you need prefill business line with lowest org value of user which data is available in organization table

and organization table has only org values 1,2,3....and organization name

and user table has organzation name field data?

what is the relation between user record organization and organization table?? if we have common field between user oragnization and org table then we can write a logic