Lookup in same table
In earlier versions one could lookup a value in the same table as the key. Now that option is gone. What I want do do is when someone enters a value say an item the price field is automatically updated. Item and price are in the same talle of file. So how do you do this in v 10?