D lookup between two tables

[punna111]

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?

[NTC]

although your post is not completely clear to me; I think you seek a Look Up field type. when one designs a table each field must be a type; the default is text but one selects number, date, etc. one of the choices is Look Up and when selected the wizard will walk you thru selecting a field from another table.

[orange]

punna111,

Your post suggests each person has only 1 interest. Is that True?
I would suggest the following set up, but we don't know you business and details.

People --->PersonInterest<-----Interest

tblPeople
PersonId
other person info

tblInterest
InterestID
InterestName

tblPersonInterest
PersonInterestId
PersonID long FK
InterestID long FK
info about this person/this interest combo

[punna111]

it is just a sample.
unfortunately i cannot change the table format. normally we go through excel and we just do Vlookup(we will just move the names right side and do vlookup in excel sheet). but here in Access it is difficult. how can i do vlookup with interest name to get the name field. is there any other way to get this??
Please let me know if you need any more details.
coming to NTC points. I didnt understand anything.

[orange]

If you want to work in Access you have to be aware of database concepts and the Access object model.
If you are familiar with spreadsheet(Excel) and its underlying data model, then you may wish to stay with Excel.

Bottom line is these are 2 different animals serving different purposes and based on different object models.

Knowing either one does not necessarily help you understand the other.

If you want a good tutorial on database table design, then work through this one. You will learn more in half an hour than a month of trial and error and (guessing). And even if you decide to stay with Excel -- it's a half hour of learning.
Good luck.

[punna111]

Thanks for the above copy. Its really very good to understand the people like me.
as i mentioned already i am a beginner. i am learning now abt the databases, relationships, Sql queries. And i want/need to learn more and more.

and i recently took the beginner training for the access.
Can you just tell me with above data is that possible to get data of name field. is there any other query for that?