Lookups in a Self-Join

[dbhill]

I'm getting spurious results, so I must need a better understanding of Self-Joins. In a database I created a self-join relationship using "Serial#" on both sides of the relationship as Key Field. I have some calculation fields in which I'd like to be able to edit the contents. Hence, a lookup of the calc field should give me the editable calc result. But no. Am I missing something really basic?

Grateful for any light,

~Dennis

[Lee Smith]

You can not edit the results of a calculation in its field, only the calculation itself, through Define Fields.

HTH

Lee

[Ugo DI LUCA]

Hi Dennis,

Seljoin Serial Num::Serial Num

Text field = A

Calc=Case(Text field = "A", 10, 50)

Numlookup = lookup from selfjoin::Calc

This will authorize any change in the Numlookup (not the calc) unless your field is formated with not allow entry. Note that this num will change back to previous value if relookup unless you use another calc to invalidate the look-up key.

[dbhill]

Thanks guys, for the responses. I wound up accomplishing what I needed using the Set Field script. This works with no ragged edges, although I would like to become more competent with the Self-Join thing. Just have to study it more.

~Dennis