hi there still can't get this to work.
the steps i took are as follows
my main table holds information on the various pages for my site (sections_sec) and the primary key is : id_sec
my images table contains uploaded images for the site (images_img) and the primary key is: id_img
my relational table is called (pageimages_pim)
the field for storing the section id (id_sec) is: idsec_pim
the field for storing the image id (id_img) is: idimg_pim
in addition i also want to store an additional field from my sections table (slug_sec) into: slugsec_pim
so i created the main update form for my sections table (using the data assist wizard)
this page works fine and updates ok.
i create a recordset called images
add an image field
<img src = "path-to-image/<?php echo($row_images['image_img']);?>" />
add a checkbox called image
<input name="image" type="checkbox" id="image" value="<?php echo $row_images['id_img']; ?>" />
i then add to the page arepeating table.
for some reason i cant select the image and checkbox and add the repeating table, as the repeating table overwrites the code.
so i create the repeating table in a separate area of the page, and then copy the image and check box into the repeating table.
I then add the manage relational table.
selecting as the main join: idsec_pim
setting its value to: <?php echo((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"") ?>
Foreign key join: idimg_pim
setting its value from the drop down: 'image' in repeat selection (images, 5)
I also want to store an additional field in my relational table so on the next step:
in the slugsec_pim field i set its value to:
<?php echo((isset($_POST["slug_sec"]))?$_POST["slug_sec"]:"") ?>
which is from the WADAUpdateForm binding
i then save the page upload it and it does not work.
i have in fact only ever been able to get the manage relational table to work using a standard repeat region,
although i dont want to use a sandard repeat region in this case as there will be a lot of images to choose from and having them horizontally tiled across the page is really the only convienient way to display them.
please find attached in the zip:
the update page
url and log-in info for the admin section so you can see the page online
he dreamweaver .ste file for the site
The page itself is called using the dynamic plugins from the framework extention
I have url rewriting in place on myserver that is why all the
$_SERVER['DOCUMENT_ROOT'] . calls in the include statements are there.
Thanks for your time