LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/ListBox/relations2listboxes.odb
File actual save date2018-07-12 12:48:29
Scanning done on2018-08-21 16:21:25
Documentation generated on2018-08-21 16:21:37
Table of contents
Relations2Listboxes
List of queries
Query name Used by Query type List of fields SQL
qPersonListbox Things|P_T_Form|Table Control 1|NumericField1 (Control) SELECT Details 
SELECT 
	"Name" || ',' || "Name2" || ',' || "Date" AS "Person", 
	"ID" 
FROM 
	"Persons" 
ORDER BY 
	"Person" ASC
qReport   SELECT Details 
SELECT 
	"Animals"."Name" AS "Animal Name", 
	"Persons"."Name" AS "Surname", 
	"Persons"."Name2" AS "Forename", 
	"Persons"."Date" AS "Birthday", 
	"Things"."Name" AS "Thing" 
FROM 
	"Persons" AS "Persons", 
	"Animals" AS "Animals", 
	"P_T" AS "P_T", 
	"Things" AS "Things" 
WHERE 
	"Persons"."AnimalID" = "Animals"."ID" 
	AND "P_T"."P_ID" = "Persons"."ID" 
	AND "P_T"."T_ID" = "Things"."ID"