Trying to build a recordset for photos and use a form input for the photos upload and a text field to add a photo category for all the photos uploaded under that category
Have a table with the columns being photos_ID, photos_image, photos_caption, photos_description, photos_era and photos_ok.
Have a form that a user inputs his photo or photos and a description of the event where the photos were taken, i.e. Cookout, Birthday Party, Trip to the beach etc. In the recordset i use where photos_ok ='yes' so the photos don't show until approved.
On the page to display the photos, i want the photos_description to be a heading and all the photos with that photos_description to show under the heading as a repeat region.
Not sure how to write the recordset in order to accomplish this?