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!