5 Replies Latest reply on Aug 4, 2011 12:34 AM by MarkMartin

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

    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