[RESOLVED] How can I get 3 tables to be shown on a rpt. from visual basci .net

[rguifarro]

hi everyone!

im useing vb.net 2003 and cr v10. first of all.
the thing is that from vb i have a on a form a textbox, botton and a crystal viewer, where the user is gonna put the ID for any client so, when he put the ID and press the botton the rpt has to be display with all the info of the ID. the desing of the rpt i all ready have it done. the BIG problem is that i cant meke the 3 tables related together and the info to be display on the rpt. nad if the user puts another ID the info off the prt should change(is the same desing of rpt for every time).

im useing a dataset object where im making the relation between the 3 tables thats fine, the thing is that have the same name for the colums that are the primary key colums. and there I had a problem it said that the cop_id_socio that is the primarykey is ambigious i change it for the 2 table to try it and it did work fine but how should i do the sql query to obtain all the info from the 3 tables.

stQuery = "SELECT * FROM Cop_Clientes, Cop_Contribucion WHERE (" & TextBox1.Text & " LIKE '%" & Me.TextBox2.Text & "%' ) " & _
"AND cop_id_socio=cop_id_socio_con" 'here is where im saying to bring me the info of the second table

would be so greatfull is someone could help me and be pacient with me cuase im new in thing of .net and cr