Ok, my first problem was fast and well solved So, I'll take it one step further
I have the following tables:
orders.ordernumber(PK)
orderlines.ordernumber(PK)orderlines.orderline(PK)
orderspecs.ordernumber(PK)orderspecs.orderline(PK)orderspecs.specline(PK)orderspecs.material(PK)orderspecs.lengthorderspecs.widthorderspecs.heightorderspecs.amount
materialuse.ordernumber(PK)materialuse.orderline(PK)materialuse.material(PK)materialuse.volume
The volume on the specline would be length*width*height*amount
I need a function that calculates the total volume on a orderline per material. Parameters would therefor be: ordernumber,orderline,material
How does this function would look like so I could use it as a Computed Column Specification Formula?
Thnx in advance
Florian