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

List of fields by table

Table name	Field name	Field type	Primary key	Description	% not Null	Average	Most positive	Oldest date	Newest date	Longest string
filter	filter_1	VARCHAR		Fields must have same properties as fields, which should be filtered.	0
	filter_2	VARCHAR			100					2
	ID	BOOLEAN	✔		100
listbox_1_view	quantity	INTEGER			100		44
	Sys.	VARCHAR			100					38
listbox_2_view	Art	VARCHAR			92					2
	quantity	INTEGER			100		7451
searchtable	Art	VARCHAR			100					2
	Autor	VARCHAR			100					157
	Datum	DATE			0			01/02/2013	11/12/2013
	ISBN	VARCHAR			84					13
	Jahr	NUMERIC			95	1987	2008
	Kuerz.	VARCHAR			99					7
	Nr.	INTEGER	✔		100		8187
	Schlagworte	VARCHAR			100					108
	Sys.	VARCHAR			99					43
	Titel	VARCHAR			100					155
	Verw.	VARCHAR			20					37
	Zunummer	VARCHAR			98					10
searchtmp	Nr.	INTEGER			100		7717