Dataset and DataTable problem

  • Thread starter Thread starter Sébastien
  • Start date Start date
S

Sébastien

I have 3 table (2 parents and a child) :

Parent1 Parent2
^ ^
\ /
Child


I want to show all items from Parent2 that correspond to the actual record
of Table1 in my form.
I want to do something like SELECT * FROM PARENTS2 WHERE
PARENT2.ID=CHILD.ID_PARENT2 AND CHILD.ID_PARENT1 = PARENT1.ID

I have a form with all the Table1 info (I created a textbox for each
informations and I use databinding from a dataset to show the datas). Then I
created a ListBox to whow the data from Table2 that match the actual record
of Table1.

Does someone can tell me how I could do that ? DO I need to make a new view
? Ohh, I forgot.. If someone update Parent2 with Form2, I want to get the
change live in Form1.

If someone can find me a solution, you're very good =)

Thank you.
 
I believe a DataRelation from Both Parent tables to the child should do it
for you.
 
Back
Top