Step 2: Choose a customer and product
Customers if (request.CustGroup != null) client.CustGroupID=request.CustGroup; else client.CustGroupID="ALL"; if (request.ProdGroup != null) client.ProdGroupID=request.ProdGroup; else client.ProdGroupID="ALL"; if (client.CustGroupID == "ALL") { write(""); } else { cursor = database.cursor( "Select CustName, CustID "+ "From Customer "+ "where CustGroupID = " + request.CustGroup + " Order by CustName"); write(""); }
Products if (client.ProdGroupID == "ALL") { write(""); } else { cursor = database.cursor( "Select ProdName, ProdID "+ "From Product "+ "where ProdGroupID = " + request.ProdGroup+ " Order by ProdName"); write(""); }