Skip to content
Question
Share
Explore

Elements


Katalog
0
Name
Unit
Cost
Price
Warehouse
Expended
Availability
1
Wood
s.m
100
200
100
100
2
Metal
r.m
200
400
200
200
3
Fabric
s.m
50
100
500
500
There are no rows in this table

Element
0
Element
Name
Unit
Cost
Quantity
Amount
Element_001
3
Wood
s.m
100
10
1000
Wood
s.m
100
15
1500
Fabric
s.m
50
20
1000
3500
Sum
Element_002
2
Metal
r.m
200
25
5000
Fabric
s.m
50
35
1750
6750
Sum
Element_003
2
Wood
s.m
100
40
4000
Fabric
s.m
50
0
4000
Sum
14250
Sum
Klient
0
Klient 1
Adam
Brown
Element_001
Element_001
Element_001
101520
Klient2
Gregory
White
Element_002
Element_002
2535
NEW TABLE
0
Product
Name
Price
Quantity
Quantity of elements
Quantity of materials
1
Element_001
Wood
200
10
6
60
2
Element_001
Wood
200
15
6
90
3
Element_001
Fabric
100
20
6
120
4
Element_002
Metal
400
25
3
75
5
Element_002
Fabric
100
35
3
105
There are no rows in this table
Did I make myself clear or do I need to add anything else?
It is too complicated to solve in a short period of time and partly due to the structure of the tables. Have a look at my costs column, the first one fails due to two elements that are the same
you need to purify your approach
what I show is chaining, that is to relate data over tables
in the table you have 3 times element 1, that is confusing


I made these tables as an example, my main document is much more complex. you can change anything you want here. Meaning that I have an item that consists of consumables that are cataloged. I know, but I dont have hours to do this

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.