I have an order form that I have made and It works perfectly on my first initial input of the form.
Parent Table "Order Builder" Has all details for customer Staff and What items are being purchased.
I can select multiple through a REF to a Child sheet called "Cart"
I Have a singular Column that calculates the total cost of all products using this Formula:
SUM ( SELECT (Cart[Total Cost], Cart[Order ID] = [_THISROW].[Related Carts]))
I need the formula to:
Problem I'm faced with is that It only works on the first order and doesn't work again after that.
Please Help Masters!
Just some quick thoughts on this issue:
I'm not completely sure if the second approach would work for you. You may be faced with some additional issues as a result but it will probably reduce performance issues.
That is a good Idea, Use what I have more as a calculator than the actual form.
Cheers I try it and see what happens!
Thanks!
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |