Hello,

I'm making some kind of inventory system.

I Have two files. On named Items and one named Amount

In file amount I have the fields Amount, Location, Type and Ordernumber.

Type is a field with a valuelist (Reserved, Semi-finished, n/a).

In the file Items I want to display the total amount of products. Eg. All amounts of Type n/a, the total amount of Reserved products and the total amount of product minus the reserved products.

I hope this makes any sense...

Can anyone help me with this.

Hello,

I solves the problem myself... It was rather simple actualy.

I created calculation fields in the Amount file for each type with an IF statement. And in the Items file I uses calculation fields for each type with the SUM statement summing the calculated field in the Amount file.

Greetings, Eric