So I've built a database that looks like this:
tblCustomers: customerID, firstname, lastname, outstandingBal
tblOrders: orderID, customerID, receivedDate, dueDate, comments
tblOrderDetails: orderID, productID, quantity, notes, unitPrice
tblProducts: productID, name, description, unitPrice
Then...