Lookup Column Question

[agure]

So I have two seperate tables i'll give an example this is not my database just showing an example to simplify:



Table 1:

Owner	Number	Address	Age
Adam	1781871781	117 example st	50

Table 2:

Owner	Age
Adam

So What I want in table 2 is to create a lookup for OWNER and then Age automatically fills in according to the value that I already looked up from OWNER.

In short when I select Adam I want it to show his age being 50 in table 2.

I know this is probably a simple thing in access i just cant seem to find the way to do this. Thanks guys.

[orange]

Select Table2.Owner, Table1.Age
From Table2 Inner Join Table1 ON
Table2.Owner = Table1.Owner
where Table2.Owner = "Adam"

What exactly is the purpose of Table2?

[agure]

Select Table2.Owner, Table1.Age
From Table2 Inner Join Table1 ON
Table2.Owner = Table1.Owner
where Table2.Owner = "Adam"

What exactly is the purpose of Table2?

I have a pretty large database and all I would like to do is everytime I lookup a value in table 2 for the Owner I automatically get the age for each owner.

My database I just provided and example but same idea.

Everytime I lookup Owner and get the value from Owner the corresponding Age shows up. The example you gave is specific to one value.

[agure]

Table 1

Owner	Number	Adress	Age
Adam	1818181717	xxyyxxyyy	50
Pete	1231231891	yxyxyxyxy	44
Osama	2131312411	xyxyxyxyxyx	22

Table 2

Owner	Age
Adam
Osama

Here is a better example...

I'm in table 2... I look up Owner and once I look it up I would like the age to show up automatically in the age column for that owner. I hope that clarifies.

[orange]

Remove the constraint ( the Where clause restricts it to Adam)
Remove the WHERE line

[agure]

Select Table2.Owner, Table1.Age
From Table2 Inner Join Table1 ON
Table2.Owner = Table1.Owner

Where would i write this expression exactly??

[orange]

It is SQL for a query.
Open your query wizard
Go to Sql view
and paste in the SQL I provided

Then run the query.

If you have any trouble try this:
http://bit.ly/1gn3djK