I am looking for possible solutions to Auto Polulate option set field on one entity with values from text field from another entity. So for example I have a field /State/ in Accounts where the data type is Text. Next, I have again the /State/ field in Opportunity where data type is /Option set/. I am trying to auto populate my state field in Opportunity form from values of State field (Text) existing in Accounts entity. If in Accounts table that field is blank then I want user to select one value from the option set.
My challenge is the data type of State field is different in both entities.
Any workaround to above issue?