AnsweredAssumed Answered

2-4 images, selecting one as Primary with a radio button in a portal

Question asked by MarkMartin on Jul 30, 2011
Latest reply on Aug 4, 2011 by MarkMartin

Title

2-4 images, selecting one as Primary with a radio button in a portal

Post

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". 

Part 2

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

Mark

Outcomes