Calendar View Displaying Key Field from Reference Column instead of Label

[Brittney_Neal]

Hello,
I’ve created a reference between my customers and orders tables. I used the label row to bring in a customer’s name to the order rather than the Unique ID in the key column. It works beautifully in the detail view but when looking at the calendar view it shows the Unique ID. I’ve tried a few different things including some expressions, a virtual column etc. but not having any luck. I’ve included some photos to demonstrate what is happening. What am I doing wrong? TYIA!

[Suvrutt_Gurjar · Accepted solution]

You may wish to try following.

Please create a dereference column in the Orders table with an expression such as
[Ref Column referencing Customers Table in Orders Table].[Label Column of Customers Table]

Say this column is called [Name for Calendar]

Please use this column in the Description setting of the Calendar view.

[Brittney_Neal]

Suvrutt_Gurjar:

referencing Customers Table in Orders Table

It worked! Thank you!