Lookup Not Responding

[outdoorsportz]

Hello,

I have an inventory control DB that involves an INVOICE, INVENTORY, PO, RECEIVING, and PRICING?DESCRIPTION. The wholesale costs are in the INVENTORY DB, and I need them in the PRICING/DESCRIPTION DB. The WHOLESALE field in PRICING/DESCRIPTION is a lookup of INVENTORY. The lookup seems to work fine, but if a change is made to the WHOLESALE field in INVENTORY, the change does not occur in PRICING/DESCRIPTION. I usually need to copy and paste the PRODUCT ID field in itself for the change to be made. Am I doing something wrong that will not allow the lookup to instantly make the change?

Thanks,

Steven

[falkaholic]

Short answer: yes you are doing something wrong. :

Loopups only happen onces. You want to use relationships, then the change will take effect. There is more the enough help around to get reolations set up right.

HTH

[trevorg]

Generally, you don't want pricing to be based upon a relationship. You want to preserve the historical pricing, and not have it update all the old invoices, etc as soon as a pricing change is made. (Unless you designed the system that way and whenever pricing changes a new item is created).

But that is the behavior of lookups. They enter once and then don't change afterward unless you do a relookup. By modifiying the ProductID field, you effectively triggered another lookup to occur.