Hello,
I am using Ms access as the backend and VB6 as the front end.
i have joined two tables in the database.
The child table has multiple records in correspondence to the record in the parent table.
The parent is easily accessible

and modified with VB but i would like to display only the corresponding records of the child table in the datagrid in VB. somehow this doesnot work, all the records are displayed in jumbled up fashion.
Pleas help asap.