How to use an image in desk/detail view taken from another table
Imagine i have two simple tables: -items (id, image, name) -images(id, image, caption)
I would like to use the same image for different items and I set up items[image] as a reference to the images tables. If I create a desk or detail view for the items table It seems there’s no way to show the referenced image as the main image for the view and I get the usual warning
“Control ‘items’ uses a display type that is best suited for data with an image column. Try adding a virtual column with the TEXT_ICON() formula” There is no way to select the image ref column as the main image in the view. The only options are auto and none
Is there any way to get the image displayed as if it were in the items table?