How to get only first attachment?


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