[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