Link through a table to

512 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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,

0 Replies 0