I'm baiscally creating custom retail labels using an excel spreadsheet and odbc connection. I've done the multi database join. I have custom sql statements for each connection.
SELECT `FLAGSHIP SKU`, `VENDOR ITEM #`, `UPC CODE`, `TAGGED PRICE`, `LOC#` FROM `'MASTER ORDER$'`
SELECT "SalesOrderNo", "ItemCode", "QuantityOrdered" FROM "SO_SalesOrderDetail"
ORDER BY SalesOrderNo, ItemCode
I created the data entry form with a text box for the Sales Order No. to be entered.
Now I want this to grab that sales order number and print all the items pertaining to that order.
i was only able to get it to print one item at a time
For Copies I have it set to the database field QuantityOrdered.
What can I do to fix this???
Note: The sales order is duplicated multiple times based off how many items are attached to the order and each item has different quantities
I'm using Bartender Professional 10.1