ASP loop or repeat help

[TC2112]

Hello everyone,

I have a simple database that has two tables.
One is Membership:
Just three fields: MemberShip ID (primary key) , Membership name and Membership Price.
The second table is Benefits.
Just two fields: Benefit ID (join with Membership ID) and Benefit name.

Here's a simple example:

Membership Table:
MemID | Name | Price
1 Individual $50.00
2 Family $200.00

The benefits table looks like this:
Ben ID | Description
1 Pool Pass
1 Park Pass
2 Pool Pass
2 Park Pass
2 Gate Pass


So, the Individual Membership costs $50.00 and includes a Pool Pass and a Park Pass
The Family Membership is $200.00 and includes a Pool Pass, Park Pass and Gate Pass.

I would like to display:

<h3>Individual Membership</h3>

(unordered list)
-Pool Pass
-Park Pass

Price: $50.00

A submit button.

Then, repeat for the next membership:

<h3>Family Mamebrship</h3>

(unordered list)
-Pool Pass
-Park Pass
-Gate Pass

Price: $200.00

Submit Button


This area would continue to repeat through all benefits.

Can anyone suggest a link or some information to point me in the right direction?

I can make the recordset, know how to display dynamic text and repeat region but am not sure how to repeat this area of information.

Thank you for your time,

Tim

[Newsgroup_User]

"TC2112" <webforumsuser@macromedia.com> wrote in message
news:fqi52u$5j1$1@forums.macromedia.com...
> Hello everyone,
> Can anyone suggest a link or some information to point me in the right
> direction?

go to http://www.tom-muck.com/ and search for his Simulated Nested Region
extension.

[TC2112]

Hi Hunter,

Thanks for taking a look. I actually have that extension and it would work well for:

Individual Membership
- pool
- park

Family Membership
- pool
- park
- gate

It's getting the submit button and the price listed after the repeating list that's driving me crazy :-)

Take care,
Tim