I have a database to organize pictures by a series of categories. Once the database has all the images in it, the focus then becomes one where users will look through the images and choose 2 to be printed out next to each other.
Ideally, I need to have a form that shows the images sitting next to each other where the user can scroll through images on the left until they find one they like and then scroll through the same set of images on the right to select the second one.
I tried using an update query to create a duplicate table of pictures so that I could create the form but when I scroll through the images on the right, it also moves the images on the left because it is a one-to-one relationship with identical data.
Is there a way to make this work?
Ideally, I need to have a form that shows the images sitting next to each other where the user can scroll through images on the left until they find one they like and then scroll through the same set of images on the right to select the second one.
I tried using an update query to create a duplicate table of pictures so that I could create the form but when I scroll through the images on the right, it also moves the images on the left because it is a one-to-one relationship with identical data.
Is there a way to make this work?
