Hello
Ok so this tool rules, but I am having one problem. I would like to update a bunch of values in a table but want to reference a few values in related tables for information only. For example I have an inventory record table. For each inventory item I would like to display a total sum of inventory items on order that match the location and part number. Similarly it would be nice to calculate the total inventory cost based on a unit price in our base part table.
I have looked at the possibility of using a view however it appears that this would like me only pull the data and would prevent me from doing the updates. Do I have to write this functionality manually or is there as I suspect a better way to get and present this information.
Thank you for your assistance in advance.
Matthew