How i can filter this

[zebhashmi]

by selecting G I want get Field3

field1	field2
A
B	A
C	B
D	B
E	C
F	D
G	E

field3

A

B

C

E

G

Field1 is Names

Field2 is father Name

if I select G (Name) I want a list of his fatter's father onward

Thank you!

[OmarBenSalem]

What?

Can u elaborate juuust a little bit more maybe?

I mean... if u want to..?

[pradosh_thakur]

what is the logic ?

[zebhashmi]

Field1 is a Names

Field2 is father Name

if i select G (Name) i want a list of his fater's father onword

[zebhashmi]

Field1 is a Names

Field2 is father Name

if i select G (Name) i want a list of his fater's father onword

[OmarBenSalem]

can u give us maybe 5 real values of each field?

what u have? and what u expect to have?

..