Ref Ref of Parent

[Geovanni_Gerard]

I dont know how to explain what I need. So be patient .

I have three tables :
Parent Table
Children Type A
Children Type B

Both types of children share the Parent ID. For specific gadget I need to take a column of Children A in Children B .

So What I am trying to get it is something like this.

[Parent ID].[Children A].[Column A] WHERE Children A[Parent ID] = Children B [Parent ID]

Regards,

Geovanni Rojas