dynamic databaseissue in Frontpage 2003

[Matt]

Hello Everyone,

I am snagged on something with FP2003 and ACCESS 2003. I have a
database with a list of images and names and a yes/no field. I can get
those images to populate a web form along with the corresponding name
using DBRW. My problem is this: I would like to have a checkbox
beside each image, and capture which images the user selected with a
submit button. When I do this by way of the wizards, I can't get a
different checkbox for each image, I have the same checkbox repeated
for each image. I need to have the checkbox properties change along
with the different images preferably to a name exactly or very similar
to the image file name. Any suggestions?
Thanks
Matt

 

[Matt]

I think I am closing in on the issue. I have a database connection to
an Access 2003 file and a primary key in that database. When I right
click the checkbox and select "Form Field Properties" is there a
formula or script I can put in the name field to call my primay key
value for that particular record?

Thanks again,

Matt.

 

[Matt]

Ok, I solved the issue by trial and error. To automatically name each
input field with the value of my primary key, I used this code

<input type="checkbox" name="<%=FP_FieldVal(fp_rs,"Main OP")%>"
value="ON">
where Main OP is my primary key.

Matt

 

[Ronx]

That should work, except you will have to remove all spaces from field
names in the database and code.
Rename Main OP to Main_OP, or to MainOP.

 

[Matt]

Ok, so I haven't really solved the problem. I have managed to make the
checkbox names dynamic. Of course they are form input and now I cannot
capture the information from the form, regardless of which option I
use.
Here is what I have:
DBRW displays <<ID>><<NAME>><<Image>>, and a checkbox
I am naming the checkbox as follows:

<input type="checkbox" name="<%=FP_FieldVal(fp_rs,"ID")%>" value="ON">

where ID is my primary key. This works fine. When I run the page I get
(from "view source")

<input type="checkbox" name="1" value="ON">

and the name value changes according to the primary key correct on down
the page

Here is what I would like to do:

On submit, go to a new page and display only the images that were
marked as checked on the previous page.

As I am trying different ways to do this, the hang up seems to be the
variable name field for each check box. How can I carry those checkbox
name values into another page?

Thanks
Matt