Why would a DREF not be recognized?
The field [deal_id] is set as the key in the deals table and I have a field named [amount_type] in the table as well. From my user_deals table, I insert a virtual column and use [deal_id].[amount_type] but the expression builder returns “unable to recognize field amount_type”.
Troubleshoot notes: *In the expression builder I look to connect with another field in the deals table [deal_id].[deal_type] and it was successful. The amount_type and deal_type fields are both ENUM’s and required fields-no variance. *I rename the amount_type field to deal_amount_type and its still not recognized.
Any help would be great! Thanks