dependent code showing

[koushik_btech20]

suppose in member table , there are member id and memeber name, now member id suppose A237 01 , M23 01 etc where A237 01 is main member but A237 02, A37 03, A237 04 thse are dependent members of A237 01. So how can I display the dependent member after selecting the head member id.... if anyone have the solution plz share ....

[#2]

Load MemberId, MemberName,

if(right(MemberId,2)='01', 'Parent', 'Child') as RelationShip

From Table.

Hope this helps.