Lookup and Relookup

[temptraq]

Hi!

I have several lookup fields in a db. Salary and adress are two of them. Salary is the reason why i use lookup, so that it does

[Vaughan]

Use an Auto-enter rather than a lookup. Or script the update with a Loop and Set Field.

[temptraq]

Thanks!

Too late to use auto-enter

I used Replace with a calculation throu the very same relation as the Lookup.

[spb]

A simpler solution for relooking up one of two fields (but not the other) would be to place the field you need relookedup (is that a word?) on a separate layout, along with the relationship's key field.

Then you can script to go to this layout, relookup, then return to your starting layout. Relookups will only happen when the field is on the active layout, so having a layout without the field you don't want affected will keep that field from relookingup (is that a word?).

Steve Brown

[Ender]

  Quote

Relookups will only happen when the field is on the active layout, so having a layout without the field you don't want affected will keep that field from relookingup (is that a word?).

Sorry Steve, I don't think this is true. All lookup fields based on a key are "Relookedup" when you do a Relookup on that key, whether or not the lookup fields are on the current layout.