Jump to content
Sign in to follow this  
outdoorsportz

Lookup Not Responding

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.