Hello,
I have a map with different tables (projects, inventory, employees). You find here.
Plan:
table projects
No. | project | CM | Inventory | Weight | ...
1 Screed 1 1,2,3,4,4
1 Screed 2 1,2,3,4,4
1 Screed 3 1,2,3,4,4
table Inventory
No. | Inventory | Buy Date | Culumn | Weight |
1 blabla 10/12/2015 1 0,3
2 blabla 10/12/2015 1 0,3
3 blabla 10/12/2015 1 0,3
4 blabla 10/12/2015 2 0,3
5 blabla 10/12/2015 2 0,3
6 blabla 10/12/2015 2 0,3
I ask me is it possible that when I write in Project/CM 1 (2,3,4 …) that libreoffice looks in Inventory search the number 1 (2,3,4 …) in Inventory/Culumn and print the No. (first row inventory) in Projects/Inventory and count the Inventory/Weight and write in Projects/Weight.
Hope I it explain to understand well. Have someone a idea for easy function?
Thank you and nice day
Silvio