I am trying to create a basis for a list of products in an MS Access Query. The basis must later be used in a form where the products are visualized with only one of the many images associated with each product.
The image name is calculated with an expression field based on the product ID and color ID, which is also the composite primary key for the table.

I have successfully created a query, the outcome of the query is to create a unique id in the database, and am able to run it as an embedded macro.