AnsweredAssumed Answered

Subtract from different tables

Question asked by dimitrisk9 on Sep 15, 2018
Latest reply on Oct 10, 2018 by philmodjunk

I have a table with one number field.

I have a second table with another number field, which relates to the first.

Say I enter the number 100 in the first table (which is the number of items received).

Then I create 2 different entries in the 2nd table, one with the number 10 and another one with 20 (It means that from the 100, I used the 10 items in entry 1 and 20 items in entry 2).

I need to make a calculation (and store it in table 1 if it is possible, as a different field) that gives me the remaining number of items from table 1. That means it subtracts from 100 the values 10 and 20 to give 70.

I hope I made it clear.