Attribute Rule: Taking attribute information from a table view to a feature class.

[AbiDhakal]

Hello GIS friends,

Hope you all are well and staying safe.

I have a question; I got a feature class and a table in sde. I want the feature class 'Recommendation' field to get populated with information from a field (Recommendation) in the table view. In my situation, 'Add Join' will not work because I am not able to make a service when I join a feature class with a table view. I was thinking more along the lines of Attribute Rule. If there is a way to insert a Trigger and update the 'Recommendation' field in the feature class with every new attribute (Recommendation) information in the table view?

Here is the picture:                        

Feature Class

ID	Recommendation
1
2
3

Table View

ID	Recommendation
1	Green
2	Blue
3	Red

Thank you for your help friends,

Abi