Please post again in another language if that would help you more.
Sent from miPhone
I can suggest two options.
- Use a relationship that matches by ID_Code to match to the one record with this value. In a script, Set Field can then update the In or Out fields to show an inventory change. A script might also perform a find for this record, but a relationship seems better to me.
- Use an "Inventory Ledger" approach where you use a basic Bookkeeping method to track inventory changes. Each time that you add or remove inventory, you create a new record with the ID_Code and an amount to enter in either the In or Out fields. You then use either a summary field (and sort your records by ID_Code) or a relationship that matches by ID_Code to compute the Sum of all of these inventory changes to get the current amount in inventory.
Both methods would require defining a "Balance" calculation field defined as: In - Out
You might find this thread on creating an Inventory Ledger useful to you.
Thanks very much, I tri it.