Instant Updating Lookup Fields.

[sicSRT8]

If I use a field from another table it updates info instantly. If I use a local field and set it to lookup info it doesnt clear out once it gathers info. Is there a way to change this.

For Example:

When I input the word Apple on

I want to cal Fruit (Which it does)

But when I go back and clear Apple in

still shows the calc of Fruit.

How can I change this?

[comment]

IIRC, you set the lookup to 'use: ' when no exact match.

---

Note that this refers to a lookup, not a calculation.

Edited May 14, 2009 by Guest

[sicSRT8]

Oh the use as " " works.