Summary layout ?

[Slobey]

Hi everyone,

I have an inventory DB that has a part table, an Entry table and an Entry Line item table. The entry table has a portal into the line item table to enter purchase orders or invoices (parts coming in and going out). I have a layout in the line item table that sums up all the additions and subtractions in a sub summary layout that shows each part once and how many are in stock. What I want is to be able to show the user this information in browse mode. Is there a way to display only 1 line item of a part with a sum quantity without being in preview mode. Do I need another table and if so how do I display records without having to create new ones? Does this make any sense?

Thanks in advance for any help you can give

[comment]

In the Parts table define a calculation field =

Sum ( LineItems::Quantity )

[Slobey]

Thanks for replying so quickly,

I thought of doing that, but my part table has alot more parts than there are in inventory and I don't want to show hundreds of zeroes.

[comment]

Why not do a Find, then? The thing is, if you need this in Browse mode (and I am excluding scripted summaries), it must be done in the Parts table.