AnsweredAssumed Answered

Calculation to lookup information in a field not working

Question asked by AmberDavis on Jul 1, 2014
Latest reply on Jul 2, 2014 by philmodjunk

Title

Calculation to lookup information in a field not working

Post

     I have a pop up menu for items that I want to link to the items part number. The Item pop up menu is connected to a value list that includes only related values from a table called "PurchaseOrders". The part# field has a calculated value of If ( IsValid ( ItemID ) ; Lookup ( Inventory 3::DYN Part #)) with context from Transactions. When an item is selected the only part number that appears is the first part number of our inventory. I hope this is just a simple calculation error. I will link a picture of my relationship web as well.

     Thank you.

Screen_Shot_2014-07-01_at_3.35.18_PM.png

Outcomes