Can't access related item from collection using Glide Pages

[SOLVED]

I’ve created a sheet ‘products’ with each row/product having a unique id.

When I create a job and add the items/products, I assign product’s unique id to a field called ‘product id’ so I can then create a relationship. The related product shows in the sheets, but I can’t access it’s data from the collection component. Am I missing something?

Many thanks

I’ve resolved this by using the lookup column type to get the details I require.

As you have found out, you can only access a specific type of data through a relation when you use lookups, or single value columns.

A relation only serves as a gateway to specific related rows.