Possible to "automatically" lookup data in a table without a query??

[AtLarge]

A field in a table can be populated by a lookup up but it has to be done manually or with a form.

A "new" table can be created with a query that matches the data.

Is it possible to skip these steps and create a field that automatically populates with the data from another table based on other common data?

I can do this in Excel but not sure it can be done in Access.

 

[way2bord]

No. Joining two tables is the point of Queries
Also, unless it's a foreign key, you would almost never want to do this
(see - wiki "Normalization")