I need help! How to vlookup value in access

[kiyu414]

How to lookup value from another table like excel?

Example: I attached a picture "Master"; this table is the master record of Code and Description. Another attached picture "Sample"; I would like to auto lookup description from master record.

How to do it??

 

[arnelgp]

you dont need to re-create the description in your table, it will be redundant. just create a query on sample and join the code field to the code field of your master.

 

[kiyu414]

you dont need to re-create the description in your table, it will be redundant. just create a query on sample and join the code field to the code field of your master.

Thanks! After that, how can I demostrate the description in the form using Sample table??

 

[arnelgp]

on query design, two table must be included, sample and master.
now to make join, simply click and drag the code field from sample table to code field of master table
double click fields to include, (on sample table, date, company, code), on master table description field.