Sir, I am doing a project of Multi-Level marketing website using ASP and MS-Access. (not ASP.NET)



There is a Downline Page where it show downline members of a specific members



for ex. (table : member )



Ref_id | Mem_id | Mem_name | Mem_address | join_date

1001 |1002 | a |kol | 10/08/08

1001 |1003 | b |asn | 12/08/08

1001 |1004 | c |crj | 12/08/08

1002 |1005 | d |kol | 13/08/08

1005 |1006 | e |kol | 14/08/08

1003 |1008 | f |kol | 16/08/08

1006 |1009 | g |kol | 18/08/08



if i want to view the downline of 1001 it will show all record data of as it is the root.



if i want to view downline of 1002

1005,1006,1009 will be return as they are co-related data.



but the problem is when I am doing "select * from member where ref_id='" & ref_id & "' "

it returns only the first level i.e.1002,1003 & 1004. But I want all the inter-related data together, If 1002 or 1003 or 1004 has any further downline.



The table structure may need to be change.



As I am new to this I heartly pray for a kind help from all my seniors and experts.



I hope you understand my problem, plz. help me.



Thanks and Regards

Email : toskg@rediffmail.com