Hi Everyone,

I am wondering what is the best way to solve this problem...

I have a table called Stocktake which has a portal linking to a table called stlineitems via a relationship with two fields representing month&year.

However, the stock exists in several locations and I want to be able to report per location. So I have a field in stlineitems called "Depot" where you select whether the machine/stock is located at the main warehouse, or at any satellite depot. However, I then require some unstored calc fields in my main inventory table representing for example, how many machines of type X exist at a particular location - such as Scotland etc.

How could I work out the total quantity of machines of a particular type in a particular location? Given that all the records for all the machines in all locations are in one table.

All help would be greatly appreciated.

Best Regards,

Jason V.

This seems like it should be handled as a report. You can create a subsummary based on your stlineitems table, grouped first by the location and then itemID.