Viewing Open Line Items

[AnthonyDixon]

I have a parts table, purchase order table, and a line items table. I want to be able to display only open purchase order line Items in a portal on the parts table based upon a part number. I have setup keys and a relationship between the parts table and the line items table, but the key in the line items table is based on a calculated result that cannot be stored so it does not work and I'm not sure where to go from here. I have included a sample file. Any help would be greatly appreciated.

Parts_File.zip

Edited November 3, 2009 by Guest

[Vaughan]

I want to be able to display only open purchase order line Items in a portal on the parts table based upon a part number.

Hmmmm.

Be careful what you label in your portals, Line Items are not Purchase Orders.

Try this sample file.

Parts_File.fp7.zip

[AnthonyDixon]

Thank You! Exactly what I was trying to accomplish. I will be careful in naming portals in the future. I was hoping that someone would understand my explanation I know it was a little unclear. Thank you again for taking the time to help.

Cheers

Anthony

[AnthonyDixon]

I spoke too soon. The portal does not get updated dynamically. If I close a purchase order the line item remains in the open portal even though it is closed. It only get updated correctly if I close and reopen the file. Any thoughts?

Thanks

Anthony