Most common from a list of images

[GW375]

I am creating a fishing app to record specifics about the fish that are caught. The app has a tables with the various types of fishing lures. Each lure has its own image. When a catch is recorded, the image of the lure used is then stored in a catch table. I am looking for a way to determine the lure with the most catches in a slice of the the catch table and store it as a virtual column in a users table. Top() will work, but the column type of image is lost. Any suggestions on how to solve this problem. Thanks so much!

[Bellave_Jayaram · Accepted solution]

In addition to the image, you will need a text. Consider using a Ref table where the key is text and the image is the label.

[GW375]

Thank you. This worked. I just used the unique LureNumber field.