Sorting Based on Repetitions

Discussion created by erickaczmarczyk on Oct 14, 2013
Latest reply on Oct 17, 2013 by erickaczmarczyk

Currently there are two tables in my database; one for inventory, one for images.


The inventory table has a field for inventory numbers and one for image numbers (this is set up as a repetition so multiple images can be referenced.

The image table has a field for image numbers and a container for the image files.


The goal is to reference the images and sort based on the order in the repetition field.


Please see image attached, it is a visual of how it is functioning now and how I would like it to work.

The image is from the inventory table. The portal on the left displays the referenced images. The repeating field on the right is the list of referenced image numbers. What I am looking to do is to have the images in the portal to sort as the reference image numbers are listed in the field on the right.


Right now the images are not sorted, they are displayed as default 1, 4, 8, 10. In this example, I would like them to sort 10, 8, 1, 4 based on the repetition numbers, 1, 2, 3, 4.


Any suggestions about how to approach this would be much appreciated.