I think it’s the late hour, and the many hours already spent on this, but I think I lost some basic knowledge, need your help
So, building a rather elaborate app with relations between sheets. For example:
Sheet one: client types
columns: clienttypecode (unique value), type
Sheet two: client
Columns: clientcode (unique value), client name, clienttypecode
Inside sheet two I created a relation column. You guessed it, relating clienttypecode to the clienttypecode column on sheet one.
On the client details screen, added a relation item and now the type is showing (and not the clienttypecode).
Now comes to novice/unfocused question: How can I disable the reverse reference option when a user clicks on the “type” on the client details screen? What happens now is that when you click it you’re sent to see the details on that row on sheet one. Sheet one in meant to be behind the scenes and not visible to users.
My current solution, which is not a real solution, is to create another column on sheet two. This column is lookup and it looks for the relation column on sheet one. This indeed generates a single value of the client type and it is not possible to click it on the client details page.
I feel super stupid for asking such a novice question. I feel I twisted the data so much it’s not possible to understand the data anymore.