Working with tables

I have two tables. The first named CONTACTS the second LOCATION.  Both tables have a common field called LOCATION ID. I have created a formula field called ADDRESS in the CONTACTS table that I want to contain the address from the LOCATION table.  Here is the code that I am using.  I am grabbing the LOCATION ID from my selected record in the CONTACTS table and using that to position myself in the LOCATION table.  The last statement should be the associated address I am lookin for.  The new address field in the CONTACTS table is left blank.  Any thoughts.

let aa := 'Location ID';
select LOCATION where 'Location ID' = aa;
let bb ;= Location.address;
bb