Jump to content

Need help with a portal based on a portal


laker_42

This topic is 7033 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

I found one of my problems, I was only showing 1 row in the portal. I changed it to 4 and it is showing up now. But if I change or add a product, its quantity on hand will not show up until I either go to another record or go into define fields and come back out. Is the problem that a commit only happens when I do the things I mentioned and the portal will not be updated until a commit is issued? If so, I will have to write a script that just does a commit and users will have to fire the script before the onhand quantity will be updated. That's not very friendly, is there another way to force the commit without a script?

Thanks!

John

Link to comment
Share on other sites

Ralph,

Ahhh...you are correct. I was overlooking the simple & obvious answer.

If I were to do the way I was headed, I would have to create a unique key in the lineitems table and relate that back to inventory, correct? (i.e. Concantenate the invoiceId & productID together). Not pretty!

Thanks!

John

Link to comment
Share on other sites

This topic is 7033 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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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