Page 1 of 1

Report gives ID# but not text

PostPosted: Sun Mar 14, 2021 1:07 am
by ChuckW44
I have created a small DB with two tables. Main info in table 1, linked to table 2, which is a drop-down list. I need a report showing the text list, but I can only get the ID numbers in table 2 on the report. How can I get the text column instead of the ID numbers?

Re: Report gives ID# but not text

PostPosted: Sun Mar 14, 2021 3:06 am
by Villeroy
Creating a query from both tables analog to this:
Code: Select all   Expand viewCollapse view
SELECT "Table1".* , "Table2"."Name" FROM "Table1", "Table2" WHERE "Table1"."XID" = "Table2"."ID"

Build the report from that query.

Re: Report gives ID# but not text

PostPosted: Sun Mar 14, 2021 12:59 pm
by Villeroy
I forgot to add a link to [Example] Relations reflected by list boxes in forms including an example database demonstrating a query "qReport" merging all kinds of data and a report based on that query.
Running the report requires LibreOffice or the report builder extension for OpenOffice. The report simply wraps the query result into a printable layout. The important thing is the query.