laker_42 Posted February 15, 2005 Share Posted February 15, 2005 I have 3 tables: ProductSales;ProductLineItems;ProductInventory. ProductSales is related to ProductLineItems via Invoice#. ProductLineItems is related to ProductInventory via ProductID. I have an order entry layout based on the Product Sales table. It has a portal based on the productLIneItems table which allows users to enter in purchased product. I have another portal on the layout that is based on the ProductInventory table. In this portal I wanted to show OnHandQuantity for the product that a user is entering. It works for the first product entered into the LineItems portal but it doesn't change when you go to a different product on another line. What am I missing that will allow me to accomplish this? Thanks for the help! John Link to comment Share on other sites More sharing options...
This topic is 6609 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now