I am a newbie. I want to do D lookup between two tables.
If i want to do dlookup relation is required between two tables? without relation cant i do dlookup?
below is example
table_one
ID myname myinterest
1 joy play
2 reh tv
3 kou browse
4 rim read
table2
ID interest name?
1 tv
2 read
3 paint
the ID are primary keys which are given by Access. i want to do d lookup in table2 in name field. how can i do that?