I have a small personal site up at www.progression-uk.com and if you go into the Entertainment section (button with video and music icons) and have a look at the DVD list area (Video sub-button), you can pick a DVD and view details for it.

I have also got screenshots for some of these DVDs and the details for these
are stored in another table with a 'DBID' field that corresponds to the 'ID' field of the DVD in the DVD table.

The trouble is that I have used the Show Region If Not Empty behaviour on
the main DVD detail page to only show the string "Show screens from <DVD
Title>" if there are entries in the DVD_Images table for this DVD (by taking the ID from the URL and using it in the SQL statement for the DVD Images table).

This works fine if you go to a DVD from the list.

However, if you go to a DVD from the list, and then use the recordset
navigation buttons at the bottom of the DVD Detail page, the ID of teh next
record is not in the URL.. therefore this SQl doesn't work.

Can anyone think of a way around this? I'm not sure if it's possible to
maybe look at the value of the field in the next record and use this in the
link behind the navigation button?

thanks,

Marc<font face='Arial'></font id='Arial'>

If i'm understanding you correctly, what i have on my site is a default image that shows if there are no "proper"images, therefore you dont need the show if recordset is not empty.
If there is an image for the record then that displays and if not then the default image that says "sorry there are no screenshots for this DVD"

Dave