Automatic update of stock items
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)