Hi, playing with an ordering system atm, its all working fine except the final printed out order, I cannot sort it
tables are
supplier
Department (in School)
Order
Order lines
I want to print the order out, showing the lines to order, the order detail like order number, the supplier detail like name and address and fax no. and the department details like name and person placing the order.
how can I get all the details I want from Orders, Suppliers and Departments into one nicely formatted block of info for printing.
I do not want to export to word, just a text print will do.