Calculation to lookup information in a field not working
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.