Hi fellow experts
I have a database with a main table called Cards which has a related table called Editions.One field in Cards (Edition) is related to the primary key in Editions. The database was originally an access database, and I have converted it into an xml file
I have the code below to populate a datagridview with the data from the cards table. This works Ok, but I just get the edition field being displayed with the codes used in the editions table. How can I get the table to display the full name of the edition which is a field in the editions table.
I'm very familliar with vb.net 2008 but my database manipulation skills are a bit rusty at the moment, so any help will be appreciated
Dim fn As String = "Cards.xml"
CardsDataSet = New System.Data.DataSet
Me.DataGridView1.DataSource = CardsDataSet
DataGridView1.DataMember = "Cards"