lookupvalue linked tables

Hi,   Please can you tell me how to do a lookupvalue function that returns a value from another (linked) table? The below test code doesn't work. A workaround is to create a column called "Name" in...