Parent Child Table relationship

[theservant]

I have a database that contain records based on the ID nr of a person
the two tables a named:
Customer_Info (Parent table)
Customer_Vid (Child table)

The relationship is set at ID nr in both tables.

Is there a way that I can view in a datagrid the Customer_Vid details the is pertaining to Customer_Info

I have tried the where function, but it still shows me all the details in the Customer_Vid table

 

[shakespeare5677]

I'm not exactly sure what you mean, but the datagrid will display exactly what the recordset it's based on is returning. So if you make sure that the select statment is proper in your ado, then everything will be fine. Also, don't forget that you can hide columns to show only select fields from the recordset, as well as use filter to show specific rows. Good luck.
-Max

 

[dqmq]

You need to join the two tables in the where clause, ie.
"where customer_info.ID = xxxx
and Customer_info.ID = customer_VID.ID"