I use Visual Basic 2008
Database is Mysql
Three tables:
1. table article
fields: item number, item description, color number, month number
100 chair 2 3
2. table colors
fields: color number, color description
1 red
2 blue
3. table months
fields: month number, month description
1 January
2 February
3 March
I want a relationship between article and table table table colors and months.
I want to see in the datagridview :
item number, item description, color , month
100 chair ,blue , March
How do I do this in Visual Basic 2008
Thanks,
Andre