Table of contents
Example_Search_and_Filter

• Tables
  • filter
  • listbox_1_view
  • listbox_2_view
  • searchtable
  • searchtmp
• Queries
  • columns_searchtable
  • filterquery
  • listbox_1
  • listbox_1_filterquery
  • listbox_1_simple
  • listbox_2
  • listbox_2_filterquery
  • listbox_2_simple
  • searchquery
• Forms
  • filter_with_macros_1
  • filter_with_macros_2
  • filter_without_macros
  • hierarchical_macrofilter
  • searchquery
  • searchtable
  • searchtable_hierarchical_macrofilter_form_directly_filtered
  • searchtable_macrofilter_form_directly_filtered
• Modules
  • Module1
• Index

Index

Name	Type	Parent name	Parent type	Used by	Uses
Art	Control	searchtable_macrofilter_form_directly_filtered	Form
Art	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Art	Control	searchtable	Form
Art	Control	searchquery	Form
Art	Control	filter_without_macros	Form
Art	Control	filter_with_macros_2	Form
Art	Control	filter_with_macros_1	Form
Art	Field	searchquery	Query
Art	Field	listbox_2_simple	Query
Art	Field	listbox_2_filterquery	Query
Art	Field	listbox_2	Query
Art	Field	filterquery	Query
Art	Field	listbox_2_view	Table
Art	Field	searchtable	Table
Art1	Field	listbox_2_simple	Query
Autor	Control	searchtable_macrofilter_form_directly_filtered	Form
Autor	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Autor	Control	searchtable	Form
Autor	Control	searchquery	Form
Autor	Control	filter_without_macros	Form
Autor	Control	filter_with_macros_2	Form
Autor	Control	filter_with_macros_1	Form
Autor	Field	searchquery	Query
Autor	Field	filterquery	Query
Autor	Field	searchtable	Table
btnReload	Control	filter_without_macros	Form
btnSave	Control	filter_without_macros	Form
btnSearch	Control	searchtable	Form
btnSearch	Control	searchquery	Form		searchstart (Procedure)
COLUMN_NAME	Field	columns_searchtable	Query
COLUMN_SIZE	Field	columns_searchtable	Query
columns_searchtable	Query		Database
Datum	Field	searchquery	Query
Datum	Field	searchtable	Table
Datumsfeld 1	Control	searchtable_macrofilter_form_directly_filtered	Form
Datumsfeld 1	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Datumsfeld 1	Control	searchquery	Form
Default Value	Field	columns_searchtable	Query
display	Field	listbox_2_filterquery	Query
display	Field	listbox_1_filterquery	Query
display_tablecontrol	Control	filter_without_macros	Form
disply_tablecontrol	Control	searchquery	Form
Example_Search_and_Filter	Database		Database
Filter	Procedure	Document.Standard.Module1	Module	filter_with_macros_1|listbox1 (Control) filter_with_macros_1|listbox2 (Control)	filter (Table)
filter	Table		Database	listbox_1_view (Table) listbox_2_view (Table) filterquery (Query) filter_with_macros_1 (Form) filter_with_macros_2 (Form) filter_without_macros (Form) Filter (Procedure) Filter_Additional_Info (Procedure)
filter_1	Field	filter	Table
filter_2	Field	filter	Table
Filter_Additional_Info	Procedure	Document.Standard.Module1	Module	filter_with_macros_2|listbox1 (Control) filter_with_macros_2|listbox2 (Control)	filter (Table)
Filter_direct	Procedure	Document.Standard.Module1	Module	searchtable_macrofilter_form_directly_filtered|listbox1 (Control)
filter_with_macros_1	Form		Database		filter (Table) filterquery (Query)
filter_with_macros_2	Form		Database		filter (Table) filterquery (Query)
filter_without_macros	Form		Database		filter (Table) filterquery (Query)
filterquery	Query		Database	listbox_1_filterquery (Query) listbox_2_filterquery (Query) filter_with_macros_1 (Form) filter_with_macros_2 (Form) filter_without_macros (Form)	searchtable (Table) filter (Table)
hidden control	Control	hierarchical_macrofilter	Form
Hierarchical_Control	Procedure	Document.Standard.Module1	Module	hierarchical_macrofilter|listbox4 (Control) hierarchical_macrofilter|listbox3 (Control) hierarchical_macrofilter|listbox2 (Control) hierarchical_macrofilter|listbox1 (Control) searchtable_hierarchical_macrofilter_form_directly_filtered|listbox4 (Control) searchtable_hierarchical_macrofilter_form_directly_filtered|listbox3 (Control) searchtable_hierarchical_macrofilter_form_directly_filtered|listbox2 (Control) searchtable_hierarchical_macrofilter_form_directly_filtered|listbox1 (Control)
hierarchical_macrofilter	Form		Database		searchtable (Table)
ID	Field	filter	Table
IFNULL( "Art" || ' - ' || "quantity", 'empty - ' || "quantity" )	Field	listbox_2	Query
IFNULL( "Sys." || ' - ' || "quantity", 'empty - ' || "quantity" )	Field	listbox_1	Query
ISBN	Control	searchtable_macrofilter_form_directly_filtered	Form
ISBN	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
ISBN	Control	searchtable	Form
ISBN	Control	searchquery	Form
ISBN	Control	filter_without_macros	Form
ISBN	Control	filter_with_macros_2	Form
ISBN	Control	filter_with_macros_1	Form
ISBN	Field	searchquery	Query
ISBN	Field	filterquery	Query
ISBN	Field	searchtable	Table
Jahr	Control	searchtable_macrofilter_form_directly_filtered	Form
Jahr	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Jahr	Control	searchtable	Form
Jahr	Control	searchquery	Form
Jahr	Control	filter_without_macros	Form
Jahr	Control	filter_with_macros_2	Form
Jahr	Control	filter_with_macros_1	Form
Jahr	Field	searchquery	Query
Jahr	Field	filterquery	Query
Jahr	Field	searchtable	Table
Kuerz.	Control	searchtable_macrofilter_form_directly_filtered	Form
Kuerz.	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Kuerz.	Control	searchtable	Form
Kuerz.	Control	searchquery	Form
Kuerz.	Control	filter_without_macros	Form
Kuerz.	Control	filter_with_macros_2	Form
Kuerz.	Control	filter_with_macros_1	Form
Kuerz.	Field	searchquery	Query
Kuerz.	Field	filterquery	Query
Kuerz.	Field	searchtable	Table
LabelField	Control	searchtable_macrofilter_form_directly_filtered	Form
LabelField	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
LabelField	Control	hierarchical_macrofilter	Form
lblListbox1	Control	filter_without_macros	Form
lblListbox1	Control	filter_with_macros_2	Form
lblListbox1	Control	filter_with_macros_1	Form
lblListbox2	Control	filter_without_macros	Form
lblListbox2	Control	filter_with_macros_2	Form
lblListbox2	Control	filter_with_macros_1	Form
lblSearchitem	Control	searchquery	Form
listbox_1	Query		Database	filter_with_macros_1|listbox1 (Control) filter_with_macros_2|listbox1 (Control)	listbox_1_view (Table)
listbox_1_filterquery	Query		Database		filterquery (Query)
listbox_1_simple	Query		Database	filter_without_macros|listbox1 (Control)	searchtable (Table)
listbox_1_view	Table		Database	listbox_1 (Query)	searchtable (Table) filter (Table)
listbox_2	Query		Database	filter_with_macros_1|listbox2 (Control) filter_with_macros_2|listbox2 (Control)	listbox_2_view (Table)
listbox_2_filterquery	Query		Database		filterquery (Query)
listbox_2_simple	Query		Database	filter_without_macros|listbox2 (Control)	searchtable (Table)
listbox_2_view	Table		Database	listbox_2 (Query)	searchtable (Table) filter (Table)
listbox1	Control	searchtable_macrofilter_form_directly_filtered	Form		Filter_direct (Procedure) searchtable (Table)
listbox1	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form		Hierarchical_Control (Procedure) searchtable (Table)
listbox1	Control	hierarchical_macrofilter	Form		Hierarchical_Control (Procedure) searchtable (Table)
listbox1	Control	filter_without_macros	Form		listbox_1_simple (Query)
listbox1	Control	filter_with_macros_2	Form		Filter_Additional_Info (Procedure) listbox_1 (Query)
listbox1	Control	filter_with_macros_1	Form		Filter (Procedure) listbox_1 (Query)
listbox2	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form		Hierarchical_Control (Procedure)
listbox2	Control	hierarchical_macrofilter	Form		Hierarchical_Control (Procedure)
listbox2	Control	filter_without_macros	Form		listbox_2_simple (Query)
listbox2	Control	filter_with_macros_2	Form		Filter_Additional_Info (Procedure) listbox_2 (Query)
listbox2	Control	filter_with_macros_1	Form		Filter (Procedure) listbox_2 (Query)
listbox3	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form		Hierarchical_Control (Procedure)
listbox3	Control	hierarchical_macrofilter	Form		Hierarchical_Control (Procedure)
listbox4	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form		Hierarchical_Control (Procedure)
listbox4	Control	hierarchical_macrofilter	Form		Hierarchical_Control (Procedure)
MainForm_tablecontrol	Control	searchtable_macrofilter_form_directly_filtered	Form
MainForm_tablecontrol	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
MainForm_tablecontrol	Control	searchtable	Form
Module1	Module		Database
Nr.	Control	searchtable_macrofilter_form_directly_filtered	Form
Nr.	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Nr.	Control	searchtable	Form
Nr.	Control	searchquery	Form
Nr.	Control	filter_without_macros	Form
Nr.	Control	filter_with_macros_2	Form
Nr.	Control	filter_with_macros_1	Form
Nr.	Field	searchquery	Query
Nr.	Field	filterquery	Query
Nr.	Field	searchtmp	Table
Nr.	Field	searchtable	Table
quantity	Field	listbox_2_view	Table
quantity	Field	listbox_1_view	Table
Schlagworte	Control	searchtable_macrofilter_form_directly_filtered	Form
Schlagworte	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Schlagworte	Control	searchtable	Form
Schlagworte	Control	searchquery	Form
Schlagworte	Control	filter_without_macros	Form
Schlagworte	Control	filter_with_macros_2	Form
Schlagworte	Control	filter_with_macros_1	Form
Schlagworte	Field	searchquery	Query
Schlagworte	Field	filterquery	Query
Schlagworte	Field	searchtable	Table
Searching	Procedure	Document.Standard.Module1	Module	searchstart (Procedure)
searchquery	Form		Database		searchquery (Query)
searchquery	Query		Database	searchquery (Form)	searchtable (Table) searchtmp (Table)
searchstart	Procedure	Document.Standard.Module1	Module	searchquery|btnSearch (Control)	searchtable (Table) Searching (Procedure)
searchtable	Form		Database		searchtable (Table)
searchtable	Table		Database	listbox_1_view (Table) listbox_2_view (Table) filterquery (Query) listbox_1_simple (Query) listbox_2_simple (Query) searchquery (Query) hierarchical_macrofilter (Form) hierarchical_macrofilter|listbox1 (Control) searchtable (Form) searchtable_hierarchical_macrofilter_form_directly_filtered (Form) searchtable_hierarchical_macrofilter_form_directly_filtered|listbox1 (Control) searchtable_macrofilter_form_directly_filtered (Form) searchtable_macrofilter_form_directly_filtered|listbox1 (Control) searchstart (Procedure)
searchtable_hierarchical_macrofilter_form_directly_filtered	Form		Database		searchtable (Table)
searchtable_macrofilter_form_directly_filtered	Form		Database		searchtable (Table)
searchtext	Control	searchquery	Form
searchtmp	Table		Database	searchquery (Query)
Sys.	Control	searchtable_macrofilter_form_directly_filtered	Form
Sys.	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Sys.	Control	searchtable	Form
Sys.	Control	searchquery	Form
Sys.	Control	filter_without_macros	Form
Sys.	Control	filter_with_macros_2	Form
Sys.	Control	filter_with_macros_1	Form
Sys.	Field	searchquery	Query
Sys.	Field	listbox_1_simple	Query
Sys.	Field	listbox_1_filterquery	Query
Sys.	Field	listbox_1	Query
Sys.	Field	filterquery	Query
Sys.	Field	listbox_1_view	Table
Sys.	Field	searchtable	Table
Sys.1	Field	listbox_1_simple	Query
tablecontrol	Control	filter_with_macros_2	Form
tablecontrol	Control	filter_with_macros_1	Form
Titel	Control	searchtable_macrofilter_form_directly_filtered	Form
Titel	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Titel	Control	searchtable	Form
Titel	Control	searchquery	Form
Titel	Control	filter_without_macros	Form
Titel	Control	filter_with_macros_2	Form
Titel	Control	filter_with_macros_1	Form
Titel	Field	searchquery	Query
Titel	Field	filterquery	Query
Titel	Field	searchtable	Table
TYPE_NAME	Field	columns_searchtable	Query
Verw.	Control	searchtable_macrofilter_form_directly_filtered	Form
Verw.	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Verw.	Control	searchtable	Form
Verw.	Control	searchquery	Form
Verw.	Control	filter_without_macros	Form
Verw.	Control	filter_with_macros_2	Form
Verw.	Control	filter_with_macros_1	Form
Verw.	Field	searchquery	Query
Verw.	Field	filterquery	Query
Verw.	Field	searchtable	Table
Zunummer	Control	searchtable_macrofilter_form_directly_filtered	Form
Zunummer	Control	searchtable_hierarchical_macrofilter_form_directly_filtered	Form
Zunummer	Control	searchtable	Form
Zunummer	Control	searchquery	Form
Zunummer	Control	filter_without_macros	Form
Zunummer	Control	filter_with_macros_2	Form
Zunummer	Control	filter_with_macros_1	Form
Zunummer	Field	searchquery	Query
Zunummer	Field	filterquery	Query
Zunummer	Field	searchtable	Table