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
Ideally ref/de-ref between Parent and Child tables work like this: # indicates a Key Column
Table1
Table2 #ColunnA.
#Column1 ColumnB
Column2 > ref Table1 ColumnC
Column3
Notice that Table1 is the Parent and Table2 is Child table. Now you can de-ref Table1 (parent) from Table2 (child) like this:
[Column2].[ColumnC]
@Daisy_Ramirez did you resolve this issue?
Hi Bellave, the issue has not been resolved. As in Leventโs example above the deals table is the parent and the user_deals is the child. I have many drefโs in the app but for some reason this particular one is not being recognized. As mentioned above. I drefโd another column in the deals table (deal_type) and it worked great.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |