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
Controls by form
Form name Control name Control type Caption X,Y Width,Height Root form Data source Master fields Child fields Required Format
Animals lblAnimalName Fixed Animal 19,51 57,16 MainForm          
  SubForm Subform       MainForm Persons (Table) ID AnimalID    
  … P_T_Form Subform         P_T (Table) ID P_ID    
  … … Table Control 1 Gridcontrol   445,128 266,278            
  … … … NumericField1 List box Things of selected person       
SELECT 
	"Name", 
	"ID" 
FROM 
	"Things" 
ORDER BY 
	"Name"
     ✔  
  … SubForm_Grid Gridcontrol   37,113 386,299            
  … … Date Date Date       Date     ✔ Standard (short)
  … … Name Text Name       Name     ✔  
  … … Name2 Text Name2       Name2     ✔  
  txtAnimalName Text   17,71 304,24 MainForm Name     ✔  
Persons dtDate Date   97,107 189,23 MainForm Date     ✔ Standard (short)
  lblAnimalID Fixed One Animal ID 321,40 53,74 MainForm          
  lblDate Fixed Birthday 18,111 80,16 MainForm          
  lblName Fixed Name 16,42 79,15 MainForm          
  lblName2 Fixed Surname 16,73 79,16 MainForm          
  listThingID List box   384,36 165,147 MainForm 
SELECT 
	"Name", 
	"ID" 
FROM 
	"Animals" 
ORDER BY 
	"Name" ASC
     ✔  
  P_T_Form Subform       MainForm P_T (Table) ID P_ID    
  … Table Control 1 Gridcontrol   51,187 265,278            
  … … NumericField1 List box Many T_IDs       
select 
	"Name", 
	"ID" 
FROM 
	"Things" 
ORDER BY 
	"Name"
     ✔  
  txtName Text   94,38 190,23 MainForm Name     ✔  
  txtName2 Text   94,69 190,24 MainForm Name2     ✔  
README AnimalID List box   240,318 152,20 P0Form_A 
select 
	"Name", 
	ID 
FROM 
	"Animals"
     ✔  
  AnimalID List box   240,318 152,20 P0Form_A 
select 
	"Name", 
	ID 
FROM 
	"Animals"
     ✔  
  AnimalID-Beschriftung Fixed Same in drop down shape: 233,293 171,20 P0Form_A          
  AnimalID-Beschriftung Fixed Same in drop down shape: 233,293 171,20 P0Form_A          
  Tabellen-Kontrollfeld 1 Gridcontrol   0,442 448,171 P0_T_Form          
  … P_ID Numeric P_ID     P0_T_Form P_ID     ✔  
  … T_ID Numeric T_ID     P0_T_Form T_ID     ✔  
  … T_ID Numeric T_ID     P0_T_Form T_ID     ✔  
Things lblName Fixed Thing Name 16,57 79,15 MainForm          
  P_T_Form Subform       MainForm P_T (Table) ID T_ID    
  … Form_Persons Subform         Persons (Table) P_ID ID    
  … … lblAnimalID Fixed One Animal ID of selected Person 353,109 54,73            
  … … listAnimalID List box   417,105 164,147   
SELECT 
	"Name", 
	"ID" 
FROM 
	"Animals" 
ORDER BY 
	"Name" ASC
     ✔  
  … PersonsForm Subform         Persons (Table) P_ID ID    
  … … AnimalID List box   181,506 152,19   
SELECT 
	"Name", 
	"ID" 
FROM 
	"Animals" AS "Animals" 
ORDER BY 
	"Name" ASC
     ✔  
  … … AnimalID-Beschriftung Fixed AnimalID 30,506 152,19            
  … … Date Date   181,479 152,20   Date     ✔ Standard (short)
  … … Date-Beschriftung Fixed Date 30,479 152,20            
  … … Name Text   177,422 152,19   Name     ✔  
  … … Name2 Text   178,449 153,20   Name2     ✔  
  … … Name2-Beschriftung Fixed Name2 27,449 152,20            
  … … Name-Beschriftung Fixed Name 26,422 152,19            
  … Table Control 1 Gridcontrol   20,104 314,278            
  … … NumericField1 List box Many P_IDs       qPersonListbox (Query)     ✔  
  txtName Text   94,53 190,23 MainForm Name     ✔