A photo field has multiple images of the product. I want to get the primary photo (first attachment) for use in other linked tables.
In the other table, the record links to the product photo via a lookup field. However it shows ALL product photos but I only want to get one photo there.
So I created a column in the product table called “Primary photo” – hoping to get the first photo only. But is this possible? Something like
FIRST{Photos}
?