How can I use a lookup table in report page?

[Paolo]

This is a tricky one. I haven't found any solution yet. In a details report page, one field of my data source is an ID and I would like to show its description from a lookup table rather than the value of the ID itself.

Is there any way to achive that? Thank you.

[CoopperBackpack]

Hello @Paolo,

This should be possible in case you have a unique ID field in the lookup table.

In this case you can set one-to-many relationship between lookup table and your data source table (that you use for a Details DataPage) and link the tables by ID field.

In the Relationship Settings check the Use display value on DataPages checkbox and select the Description field in the Display Value dropdown.

I think, these articles will be helpful 
https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/
https://howto.caspio.com/tables-and-views/relationships/relationship-settings/