DATABASE relationship between tables

[ali3nn]

Hello i created a database and in this database i have 2 tables - dbo.Customer and dbo.Visits, i created a foreignkey in dbo.Visits CustomerID. I want one Customer can have multiple visits, i created it but dont know how to show these records in datagridview for Customer1 and these multiple datas.



How to show datagridview example like this

Customer1 | Date of Visit | Treatment | Price
---------------------------------------------------
ID1 | 1.1.2011 | treatment1| 12$
---------------------------------------------------
ID1 | 2.1.2011 | treatment2| 26$
---------------------------------------------------
ID1 | 1.7.2011 | treatment3| 22$
----------------------------------------------------

ID1 is Customer1(Foreignkey)


If anyone could help me it would be to nice.