I'm new to sharepoint and I wanted to create list about employee information, in which Experince level of employee is calculated based on its designation where, Experience level is text area and designation is choice coloumn. For an example,
There is one multiple choice field like Manager,Associate,Trainee,..etc and a single line field in which the value associated to it should be directly be inserted into it. For eg- If I select Manager from mulitple choice field then 7-8 yrs should be displayed in single line of text field automatically or if I select Associate from mulitple choice field then 5-6 yrs should be displayed in single line of text field automatically or similarly. For that should I create a lookup or suggest me some solution?