Updating, refreshing value lists...

[Uncle Knuckles]

There is probably an easy explanation for this, but it is keeping me up at night:

I have a calculation field in one DB ("first_name" & "/" "computer_model") that is being used by a value list in another DB as a pop-up menu. It works fine until I update the first DB. The changes are reflected in the pop-up menu, but not in previously created records. I would like all previous records to update with the new information. Any clues as to what I am doing wrong?

[djgogi]

quote:

---

Originally posted by Uncle Knuckles:

There is probably an easy explanation for this, but it is keeping me up at night:

I have a calculation field in one DB ("first_name" & "/" "computer_model") that is being used by a value list in another DB as a pop-up menu. It works fine until I update the first DB. The changes are reflected in the pop-up menu, but not in previously created records. I would like all previous records to update with the new information. Any clues as to what I am doing wrong?

---

That's because once assigned the values have been stored in your second DB .IE you didn't store the formula (which is in DB 1) but the value that reflects the state of the formula in the moment of the assignament.

HTH

Dj