Skip to main content

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

Be the first to reply!

Reply