AnsweredAssumed Answered

Automatic update of stock items

Question asked by TeodoraKolarova on Jan 6, 2012
Latest reply on Jan 6, 2012 by philmodjunk

Title

Automatic update of stock items

Post

Hello, I'm bigginer in Filemaker Pro. Excuse me, if someone else had been asked the same question.

I'm working whit starter solution Invoices, but I made a lot of changes on it. 

So, in Table Product I put field open stock quantity, sold quantity & rest quantity.

In Table Line Item I changed Order Quantity from 1 to different sold quantities ( 2, 3, 4 etc.).

But now I don't know what function I have to use for automatic update of field Rest quantity.

Excample: I have 3 pc boats in open stock (Table Products), new record Invoice 1 i sell 1 pc from these boats, In new record Invoice 3 i sell again 1 pc from these boats.

So, what I have to do to see in Table Products for Record Boat - sold quantity 2 and in field rest quantity 1 (automatically)

Outcomes