HELP.. Recordset JOIN tables

[Addy_31]

okay.. im new to this, and need some help, as i have spent all bank holiday
trying to sort this.

I have 1 database, with 2 tables.

table 1 = Info & table 2 = User

Both tables have a common primery colume called Member which is the number of
the record. so:
User.member '2' and Info.member '2' holds info for that member.

I am tring to create a account page, and need a recordset that if User.member
and Info.member equal the same, then filter all the Info tables information.
But every time i try, it just shows the first record.....

I hope i have explained this right... please help me if you can.

Thanks Addy

[Paul Whitham TMM]

Best approach is to create the join in the database itself, and then use the
resulting query rather than a table to bring the code to the page


--
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]

"Addy_31" <webforumsuser@macromedia.com> wrote in message
news:d57i0u$14g$1@forums.macromedia.com...

> okay.. im new to this, and need some help, as i have spent all bank

holiday

> trying to sort this.
>
> I have 1 database, with 2 tables.
>
> table 1 = Info & table 2 = User
>
> Both tables have a common primery colume called Member which is the

number of

> the record. so:
> User.member '2' and Info.member '2' holds info for that member.
>
> I am tring to create a account page, and need a recordset that if

User.member

> and Info.member equal the same, then filter all the Info tables

information.

> But every time i try, it just shows the first record.....
>
> I hope i have explained this right... please help me if you can.
>
> Thanks Addy
>