Filter based on repeat region value

[Guest]

I have a repeat region which outputs a list of lessons. Each lesson has a set of details.

I have 2 record sets

rslessonName (which contains the following columns) id, courseID, lessonID, lessonName

rslessonDetails (which contains the following columns) id, lessonID, description_1, description_2....to description_25

The repeat region is filtered by a URL Parameter courseID and is set to ascending order based on lessonID

so that part works fine

what I want to do is take the value lessonID during the repeat region and have the rslessonDetails record set display.

I have tried all types of filtering ... but I can't get anything to work

any suggestions???

[Newsgroup_User]

cdembek wrote:
> I have a repeat region which outputs a list of lessons. Each lesson has a set
> of details.
>
> I have 2 record sets

You should join the tables to create a single recordset.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Guest]

Thanks for info.. I am going to do a search to learn more about joining tables

Any chance you can provide an example??

[Newsgroup_User]

cdembek wrote:
> Thanks for info.. I am going to do a search to learn more about joining tables
>
> Any chance you can provide an example??

The syntax for joining tables depends on which database you're using.
However, a simple example is this:

SELECT * FROM table1, table2
WHERE table1.id = table2.id

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Guest]

Dave thanks for the help..