[Solved] Form Control Not Displaying data
[Solved] Form Control Not Displaying data
Anyone have time to quickly open the attached db Invoice & Details Form and find what is stopping the Customer_ID from displaying it's linked Invoices Table field data ? All the other fields for the Invoices Table display fine but not the Customer_ID field for some puzzling reason. Could it be a bug ? Ta
- Attachments
-
- buydca.odb
- No macros as security risk are used.
- (74.2 KiB) Downloaded 231 times
Last edited by chris-nz on Sat Jun 02, 2018 12:43 am, edited 1 time in total.
Apache OpenOffice 4.1.5 on Windows 10 Tablet
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Form Control Not Displaying data
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
However, if you just want to display the Customer_ID value you could use
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
SELECT "LastName" || ', ' || "FirstName" AS "Customer Name", "CustomerID" FROM "Customers" AS "CustomerID"
ORDER BY "LastName" ASC, "FirstName" ASC;
Code: Select all
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.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11