Hi, I'm sure I'm being a bit stupid, I hope that someone can help.
I have 4 tables "estimate" "orders" "Delivery Notes" and "invoice"
I need to have many estimates but not all estimates become Orders, 1 have resolved this by using this script:-
set field [orders::__fkEstimateID = Estimate:: _pkEstimateID
Which gives a unique order record related to just one specific estimate record
My problem is that now I have to take that order information including all data for the related estimate table and show it in multiple delivery notes (i.e. each order may have many delivery notes relating to just one order)
I think the Invoice should be more straight forward as each order has just one invoice.