Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ....
Load MemberId, MemberName,
if(right(MemberId,2)='01', 'Parent', 'Child') as RelationShip
From Table.
Hope this helps.