I have a table Opportunities having a column SeasonalityId (type number) that refers to the column Id (type number) in the table EnumSeasonality. In the table EnumSeasonality there are three rows and also the column Name1 (text) having 3 values: summer, winter, multiseason. → I need the column Name1 in the table Opportunities.
What I did. In table Opportunities, I changed the type of the SeasonalityId column into Ref and completed [SeasonalityID].[Name1] under Initial Value (I understand it is Dereference Expression). In the app, I expected the values from Name1 under the column SeasonalityId which obviously does not work.
Can you advise, please, what I did wrong?