2-4 images, selecting one as Primary with a radio button in a portal
I have searched the forums but can't find a solution. If there is a link to this solution already, please let me know.
I have 2 tables
1st table is Product table, with one exclusive Product ID
2nd table is the ProductImage table, one record per image. I have a relationship between the 2 tables setup (ProductID).
I'd like to add the images through a portal in a Product table form.
I'd like to have a radio button below the image (in the portal) to select whether it is the "Primary" image. I would like all other images be "Secondary".
I would like to be able to change the Primary. Changing another image (in the portal) to be the Primary, while the old Primary is then changed automatically to be secondary. I messed around with yes/no in a value list to do this, but it is necessary to have only one Primary image to show up in a view for that ProductID.
I also need to export the data with the Primary record being a "1" and all Secondary image records being a "0".
I would like to then have the Primary image show up as the selected image in the ProductID data table. Is this possible?
Thanks for any help