Dynamic Text ???

[Gm3512]

we have a table with repeating rows. there are about 20 feilds in the table.
however the table returns values that referncae another table.

We want this dynamic text field
<td><%=(rs_termdata.Fields.Item("termType").Value) %></td> to take the value 1
or 2 etc. from termdata table termType and populate the filed with the
description from termTypeDesc table. How does one accomplish this?

THanks
G

[Paul Whitham TMM]

You need to write a SQL statement to join the two tables. The simplest way
to do this is to write a query in the database and then use that as the
source of your recordset rather than a table.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Gm3512" <webforumsuser@macromedia.com> wrote in message
news:d5140s$ddj$1@forums.macromedia.com...

> we have a table with repeating rows. there are about 20 feilds in the

table.

> however the table returns values that referncae another table.
>
> We want this dynamic text field
> <td><%=(rs_termdata.Fields.Item("termType").Value) %></td> to take the

value 1

> or 2 etc. from termdata table termType and populate the filed with the
> description from termTypeDesc table. How does one accomplish this?
>
> THanks
> G
>