dt1
Code:
ID Animal
1 Monkey
2 Cat
3 Dog
4 Fish
dt2
Code:
ID Activity
1 Walk
2 Swim
3 Climb
dtMain
Code:
ID Animal Activity Comment
1 1 3 Blah blah
2 4 2 foobar
I want to display....
Code:
ID Animal Activity Comment
1 Monkey Climb Blah blah
2 Fish Swim foobar
Hi there,
I have a problem here, not sure how to tackle this one. I have a datatable (dtMain) which has columns which I want to replace the values in a datatable with the descriptor of the lookup tables.
Anyone have any ideas at all? Is it even possible?
Many many thanks in advance!