Jump to content

Calculation field based on a a set of related records


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

Recommended Posts

Posted

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.

Posted

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.

This topic is 5929 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.