Displaying a field in an Extra table relationship, that is linked to a second table

Hi,

On a request we are trying to show the product description for a custom field using an Extra table relationship.

However we cannot seem to add these fields.  The setup is as follows.

Against the request is the Product Selection field.

Which is an Extra table relation to the Installed Products table.

The Installed Products table has a Product Code field.

Which is also an Extra table relationship, to the Product Name table.

I can show "Product Code" from the "Installed Products" table, but I cannot see anyway of showing the "Product Description" from the "Product Name" table in the relationship chooser on the request.

Is this possible?

Many thanks,

Trevor

Inga svar ännu!