Plan is the delivery form is based on the quantity, delivery note on the place of delivery, delivery time, delivery quantity, how can these information to implement directly from the quantity plan to come over, or click on the delivery note, when new popup window shows the plan, the plan choice content in from the window, on the delivery note is automatically generated a record, and the record already has the delivery location, delivery time and delivery of information, thank you

CodePudding user response:

Select the delivery place, delivery time, delivery capacity into: a: b: c from the quantity plan where number='XXX'