Updateing a container field

[oilman]

Hi all

I have a form where i insert a sketch of a weld detail used in qualifying a welder. Everything works perfectly except went the operator picks the wrong weld detail. The operator picks the weld detail by value list. The joint details are storged in another db which has only one field define as a repeating global field. There are seven sketches. The value list is attached to another field. The container field is formatted as an unstorged auto-enter calculated value as follows:

case(joint="Single bevel",get repetition joint:joint,1),

(joint="Double bevel",get repetition joint:joint,2) and so on for the seven sketches.

When the operator pickes a wrong description in the value list and the sketch is insert, the container field will not update when a new description is pick in the value list. How can i get the sketch to change when a new description is chosen.

Any help will be greatly appreciated

Thanks

Lionel

[cjaeger]

auto-enter calcs only update if the field is empty.

lookups update whenever the main key is changed & change commited (exit field/record).

In your case, I would rather use an (unstored) calculation, because the images are not likely to change, unless you have a good reason for keeping duplicates of the image in your 2nd database.

[oilman]

Hi Christian

I change the field format to calculation instead of container but this does not bring the sketch from the other db. If you format the field as a container, then the only option that i can see is to have a auto-enter calculation. Am I missing something. Would you please explain in a little more detail.

Thanks

Lionel

[oilman]

Hi Christian

Got it figure out

Thanks for the help

Lionel