# Database Architecture

**URL:** https://forum.adalo.com/t/database-architecture/3602
**Category:** Get Help
**Created:** [August 27, 2020, 9:33am UTC](https://forum.adalo.com/t/database-architecture/3602 "2020-08-27T09:33:43Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![majumps](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@majumps](https://forum.adalo.com/u/majumps)
#### Post date: [August 27, 2020, 9:33am UTC](https://forum.adalo.com/t/database-architecture/3602/1 "2020-08-27T09:33:43Z")

</div>

Hi All -

I am having some real difficulty solving how to cycle through several multiple properties in a collection column.

Each workout has multiple single exercises associated with it  
Each single exercise has its own image

I want to have a screen where I can press a button and cycle through the images of each workout, but does anyone have any suggestions on the best way to filter the collection so I can show the images in order when the button is pushed?

 ![Screen Shot 2020-08-27 at 16.29.40](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/00a1173cd82e48ee1c6b4c8b375b427e040cc566.png)

---

<div class="post-metadata">

### Author: ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)
#### Post date: [August 27, 2020, 12:19pm UTC](https://forum.adalo.com/t/database-architecture/3602/2 "2020-08-27T12:19:12Z")

</div>

Hi @majumps,

Seems that these links might help:  
[Image Gallery examples (my first try :) )](https://forum.adalo.com/t/image-gallery-examples-my-first-try/2848) (3rd gallery type)  
[Adalo: Creating a Rotating Image Carousel or Gallery with Unlimited Images](https://forum.adalo.com/t/adalo-creating-a-rotating-image-carousel-or-gallery-with-unlimited-images/2658)

As for the order: you may want to create an additional field of Single\_Excersize\_ID, make it numeric, put the IDs in order you want. If you use a temporary internal property for storing current ID, and change it +1 / -1 when pressing Next or Prev, you get the order.  
This is what’s explained in 3rd gallery type example video.

You can also do that with the approach from 2nd video, I think.

---

<div class="post-metadata">

### Author: ![majumps](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@majumps](https://forum.adalo.com/u/majumps)
#### Post date: [August 27, 2020, 12:26pm UTC](https://forum.adalo.com/t/database-architecture/3602/3 "2020-08-27T12:26:17Z")

</div>

Thanks @Victor

Really appreciated!

The third gallery is the one I am after.

I checked the database, and its not quite what i expected (having all images store in the same group in the database) but definitely gets the job done.

Thanks very much!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)
#### Post date: [September 6, 2020, 12:26pm UTC](https://forum.adalo.com/t/database-architecture/3602/4 "2020-09-06T12:26:22Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.