PDA

View Full Version : HELP... Recordsets and JOIN tables


Addy
05-03-2005, 10:53 AM
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