Why is this lookup not working?

[ssseeesss]

I have three tables. The purpose is to get the value from the third table through lookup or calculation by setting the value in the second one.

TableOne

--------

ID

TableTwoID

Value

TableTwo

---------

ID

Name

TableThree

-----------

Name

Value

Relationship:

TableOne::TableTwoID=TableTwo::ID

TableTwo::Name=TableThree::Name

I set up TableOne::Value=TableThree::Value calculation. If I change the TableTwo::Name, TableOne won't get the value from TableThree. Why is this relationship not working?

[bcooney]

Each table should have a primary key. Therefore, you should not relate Table2 to Table3 using a name field.

You do not need the calculation in Table1. Simply place the related field from Table3 on the table1 layout.