Simple question, can’t seem to work it out.
Table 1: Orders table with mutlple records all containing an ID for the product it relates to. (I have used the API to constantly add the product orders to a new record constantly)
Table 2: Stock list that counts how many records with the product id appear in the order list and subtracts from total stock (static number)
My issue is I don’t know how to count how many records in table 1 and display in table 2. I can do all the other formula parts of the problem, but getting the count of records in a different table I can;t seem to understand how to do.
Thanks for assistance in advance!