Hi all
I have an orders table, an order line items table and a products table.
In interface, i want my staff to make orders using the products table where they 'add product to new or existing order'.
So when they click on the product this should bring up order line items form to add quantity, sell price etc of selected product and then either create new order (parent table of order line items) or link to existing order (order ID, vendor, consignee etc)
Any ideas?
Thank you!