Link through a table to

Hi I have following problem:

in tables:
INVENTORY each row is a product
MATERIAL FOR PROJECTS each row links to one product from inventory and shows its total usage on one project - rollup of one field in the table below:
MOVEMENTS: each row moves certain number of pieces of one product from INVENTORY to one project

Is there an option, when adding a MOVEMENT, to update the number of pieces in INVENTORY automaticaly through the table MATERIAL FOR PROJECTS without manualy linking each MOVEMENT to the INVENTORY? - Since it is already linked to products in MATERIAL FOR PROJECTS, the system already knows which product in the inventory I am moving.

It would save a lot of work if I do not have to enter manually the product twice in the same row of one MOVEMENT enty (once link to MATERIAL FOR PROJECTS, second to INVENTORY).

Thank you,
Adam

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.