by UnklDonald418 » Fri Jun 01, 2018 8:14 pm
Your Customer_ID control is a little confusing.
You are using a ListBox control, but the Sql query only returns one field. A ListBox query needs to return 2 fields, the display field followed by the boundfield.
Normally it would be something like
- Code: Select all Expand viewCollapse view
SELECT "LastName" || ', ' || "FirstName" AS "Customer Name", "CustomerID" FROM "Customers" AS "CustomerID"
ORDER BY "LastName" ASC, "FirstName" ASC;
However, if you just want to display the Customer_ID value you could use
- Code: Select all Expand viewCollapse view
SELECT "CustomerID", "CustomerID" FROM "Customers";
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional