Controls by form

Controls by form
Form name	Control name	Control type	Caption	X,Y	Width,Height	Root form	Data source	Master fields	Child fields	On push	Events by control	Required	Format
Loan	Button 1	Button	Loan	37,18	102,25	Navigation
	Button 2	Button	Recall	170,18	101,25	Navigation					OnActionPerformed
	Button 3	Button	Reader	302,18	101,25	Navigation					OnActionPerformed
	Button 4	Button	Media	434,18	102,25	Navigation					OnActionPerformed
	Choose_Reader	Subform				Filter	Reader_Input_Filter (Query)
	… Button 1	Button	OK	611,80	32,26					Refresh form
	… Labelfield 1	Fixed	Loan for Reader	37,263	190,26
	… Navigationbar 1	Navigation bar		37,206	663,32
	… Return	Subform					Media_Loan_Balance_Time (Query)	ID	Reader_ID
	… … Labelfield 1	Fixed	Return	62,489	190,27
	… … Tablecontrol	Gridcontrol		37,521	801,184
	… … … Loan_Date	Date	Loan Date				Loan_Date						Standard (short)
	… … … Media_ID	Text	Medium				Medium
	… … … Numeric Field 1	Numeric	Extension				Extension
	… … … Numeric Field 2	Formatted	Balance Time				BalanceTime						0 [$Days];[ROT]-0 [$Days]
	… … … Return_Date	List box	Return Date				Current_Date (Query)				OnFocusLost	✔
	… … … Textfield 1	Formatted	Loan Days				LoanDays						0 [$Days]
	… Show_Reader	Subform					Reader_Input_Filter (Query)	ID	ID
	… … Loan	Subform					Loan_not_locked (Query)	ID	ID
	… … … Datefield 1	Date		163,295	115,28		cur_Date						Standard (short)
	… … … Input	Subform					Loan (Table)	ID cur_Date	Reader_ID Loan_Date
	… … … … Listfield 1	List box		340,295	309,28		Listbox_Title_MediaID_not_loan (Query)				OnChanged	✔
	… … … Labelfield 1	Fixed	Loan Date:	62,295	96,28
	… … … Show	Subform					Media_Loan_Balance_Time (Query)	ID cur_Date	Reader_ID Loan_Date
	… … … … Labelfield 1	Fixed	current Loan	62,322	190,26
	… … … … Tablecontrol	Gridcontrol		37,353	801,126
	… … … … … Loan_Date	Date	Loan Date				Loan_Date					✔	Standard (short)
	… … … … … Media_ID	Text	Medium				Medium
	… … Textbox 1	Text		230,263	600,26		Name
	… Tablecontrol 1	Gridcontrol		37,61	379,127
	… … Numerisches Feld 1	Numeric	ID				ID					✔
	… … TextField1	Text	First Name				FirstName					✔
	… … TextField2	Text	Last Name				LastName					✔
	Labelfield 1	Fixed	Filter (Last Name)	453,61	146,20	Filter
	Textbox 1	Text		453,80	146,26	Filter	Filter					✔
Loan_Barcode	Form	Subform				Filter	Reader_Input_Filter (Query)
	… Button 1	Button	OK	611,50	32,26					Refresh form
	… Labelfield 1	Fixed	Loan for Reader	37,233	190,26
	… Loan	Subform					Loan_not_locked (Query)	ID	ID
	… … Form	Subform					Loan (Table)	ID	Reader_ID
	… … … Datefield 1	Date		214,264	152,20		Loan_Date					✔	Standard (short)
	… … … Form	Subform					Loan (Table)	Loan_Date Reader_ID	Loan_Date Reader_ID
	… … … … Tablecontrol	Gridcontrol		409,263	203,178
	… … … … … Media_ID	Numeric	Medium				Media_ID_BC					✔
	… … … Labelfield 1	Fixed	Loan Date	63,264	152,20
	… Navigationbar 1	Navigation bar		37,176	663,32
	… Return	Subform					Media_Loan_Balance_Time (Query)	ID	Reader_ID
	… … Labelfield 1	Fixed	Return	62,459	190,27
	… … Tablecontrol	Gridcontrol		37,491	801,184
	… … … Loan_Date	Date	Loan Date				Loan_Date						Standard (short)
	… … … Media_ID	Text	Medium				Medium
	… … … Numeric Field 1	Numeric	Extension				Extension
	… … … Numeric Field 2	Formatted	Balance Time				BalanceTime						0 [$Days];[ROT]-0 [$Days]
	… … … Return_Date	Date	Return Date				Return_Date					✔	Standard (short)
	… … … Textfield 1	Formatted	Loan Days				LoanDays						0 [$Days]
	… Tablecontrol 1	Gridcontrol		37,31	341,127
	… … TextField1	Text	First Name				FirstName					✔
	… … TextField2	Text	Last Name				LastName					✔
	… Textbox 1	Text		233,233	599,26		Name
	Labelfield 1	Fixed	Filter (Last Name)	453,31	146,20	Filter
	Textbox 1	Text		453,50	146,26	Filter	Filter					✔
Maintenance	Adress	Subform				Street	Adress (Table)	ID	Street_ID
	… Tablecontrol 1	Gridcontrol		1058,182	341,96
	… … Listfield 1	List box	Postcode and Town				SELECT "Postcode"."Postcode" \|\| ' ' \|\| "Town"."Town", "Postcode"."ID" FROM "Postcode", "Town" WHERE "Postcode"."Town_ID" = "Town"."ID" ORDER BY "Postcode"."Postcode" ASC, "Town"."Town" ASC					✔
	… … Numeric Field 1	Numeric	Adress_ID				ID					✔
	… … Textfield 1	Text	HouseNo.				No					✔
	Labelfield 1	Fixed	Maintenance of Tables - all Tables are filtered	37,6	575,26	Design
	Labelfield 2	Fixed	Filteradjustment: All tables whould show those values, which aren't referenced by a foreign-key from another table.	755,623	644,39	Design
	Media	Subform				Publisher	Media (Table)	ID	Publisher_ID
	Media	Subform				Town	Media (Table)	ID	Town_ID
	Media	Subform				Mediastyle	Media (Table)	ID	Mediastyle_ID
	Media	Subform				Category	Media (Table)	ID	Category_ID
	… Tabellen-Kontrollfeld 1	Gridcontrol		340,623	341,96
	… … Listfield 1	List box	Town				SELECT "Town", "ID" FROM "Town" ORDER BY "Town" ASC					✔
	… … Textfield 1	Text	Title				Title					✔
	… Tablecontrol 1	Gridcontrol		1058,37	341,96
	… Tablecontrol 1	Gridcontrol		340,472	341,95
	… Tablecontrol 1	Gridcontrol		340,327	341,96
	… … Listfield 1	List box	Publisher				SELECT "Publisher", "ID" FROM "Publisher" ORDER BY "Publisher" ASC					✔
	… … Listfield 1	List box	Mediastyle				SELECT "Mediastyle" \|\| IFNULL(' > ' \|\| "Loantime", ''), "ID" FROM "Mediastyle" ORDER BY "Mediastyle" ASC					✔
	… … Listfield 1	List box	Category				SELECT "Category" \|\| IFNULL(' > ' \|\| "Description", ''), "ID" FROM "Category" ORDER BY "Category"					✔
	… … Textfield 1	Text	Title				Title					✔
	… … Textfield 1	Text	Title				Title					✔
	… … Textfield 1	Text	Title				Title					✔
	Navigationbar 1	Navigation bar		755,573	644,26	Grade
	Navigationbar 1	Navigation bar		755,428	644,26	Class
	Navigationbar 1	Navigation bar		755,283	644,26	Street
	Navigationbar 1	Navigation bar		755,138	644,26	Publisher
	Navigationbar 1	Navigation bar		37,806	644,26	Town
	Navigationbar 1	Navigation bar		37,573	644,26	Mediastyle
	Navigationbar 1	Navigation bar		37,428	644,26	Category
	Navigationbar 1	Navigation bar		37,283	644,26	Author_Add
	Navigationbar 1	Navigation bar		37,138	644,26	Author
	Postcode	Subform				Town	Postcode (Table)	ID	Town_ID
	… Adress	Subform					Adress (Table)	ID	Postcode_ID
	… … Tablecontrol 1	Gridcontrol		642,724	228,95
	… … … Numeric Field 1	Numeric	Adress_ID				ID					✔
	… … … Textfield 1	Text	Country				Country					✔
	… Tablecontrol 1	Gridcontrol		340,724	227,95
	… … Listfield 1	List box	Town				SELECT "Town", "ID" FROM "Town" ORDER BY "Town" ASC					✔
	… … Textfield 1	Text	Postcode				Postcode					✔
	rel_Media_Author	Subform				Author_Add	rel_Media_Author (Table)	ID	Author_Add_ID
	rel_Media_Author	Subform				Author	rel_Media_Author (Table)	ID	Author_ID
	… Media	Subform					Media (Table)	Media_ID	ID
	… Media	Subform					Media (Table)	Media_ID	ID
	… … Tablecontrol 1	Gridcontrol		548,182	133,96
	… … Tablecontrol 1	Gridcontrol		548,37	133,96
	… … … Textfield 1	Text	Title				Title					✔
	… … … Textfield 1	Text	Title				Title					✔
	… Tablecontrol 1	Gridcontrol		302,37	209,96
	… Tablecontrol 1	Gridcontrol		302,182	209,96
	… … Numeric Feld 3	Numeric	Author_Sort				Author_Sort
	… … Numeric Field 2	List box	Author				SELECT "LastName" \|\| IFNULL(', ' \|\| "FirstName", ''), "ID" FROM "Author" ORDER BY "LastName" ASC, "FirstName" ASC					✔
	… … Numeric Field 2	List box	Author				SELECT "LastName" \|\| IFNULL(', ' \|\| "FirstName", ''), "ID" FROM "Author" ORDER BY "LastName" ASC, "FirstName" ASC					✔
	… … Numeric Field 3	List box	Add				SELECT "Author_Add", "ID" FROM "Author_Add" ORDER BY "Author_Add" ASC
	Schoolclass	Subform				Grade	Schoolclass (Table)	ID	Grade_ID
	Schoolclass	Subform				Class	Schoolclass (Table)	ID	Class_ID
	… Tabellen-Kontrollfeld 1	Gridcontrol		1058,327	272,96
	… … Listfield 1	List box	Grade				SELECT "Grade", "ID" FROM "Grade" ORDER BY "Grade" ASC					✔
	… … Numeric Field 1	Numeric	Schoolclass_ID				ID					✔
	… Tablecontrol 1	Gridcontrol		1058,472	272,95
	… … Listfield 1	List box	Class				SELECT "Class", "ID" FROM "Class" ORDER BY "Class" ASC					✔
	… … Numeric Field 1	Numeric	Schoolclass_ID				ID					✔
	Tablecontrol 1	Gridcontrol		755,327	228,96	Class
	Tablecontrol 1	Gridcontrol		37,182	228,96	Author_Add
	Tablecontrol 1	Gridcontrol		37,37	228,96	Author
	Tablecontrol 1	Gridcontrol		755,472	228,95	Grade
	Tablecontrol 1	Gridcontrol		755,182	228,96	Street
	Tablecontrol 1	Gridcontrol		755,37	228,96	Publisher
	Tablecontrol 1	Gridcontrol		37,667	228,96	Town
	Tablecontrol 1	Gridcontrol		37,472	228,95	Mediastyle
	Tablecontrol 1	Gridcontrol		37,327	228,96	Category
	… Numeric Field 1	Numeric	Grade			Grade	Grade					✔
	… Numeric Field 1	Formatted	Loantime			Mediastyle	Loantime						0 [$Days]
	… Textfield 1	Text	Class			Class	Class					✔
	… Textfield 1	Text	Author_Add			Author_Add	Author_Add					✔
	… Textfield 1	Text	Last Name			Author	LastName					✔
	… Textfield 1	Text	Street			Street	Street					✔
	… Textfield 1	Text	Publisher			Publisher	Publisher					✔
	… Textfield 1	Text	Town			Town	Town					✔
	… Textfield 1	Text	Mediastyle			Mediastyle	Mediastyle					✔
	… Textfield 1	Text	Category			Category	Category					✔
	… Textfield 2	Text	First Name			Author	FirstName					✔
	… Textfield 2	Text	Description			Category	Description					✔
Media	Author	Subform				MainForm	rel_Media_Author (Table)	ID	Media_ID		OnApproveRowChange OnCursorMoved
	… comAdd	Combo box		390,403	140,26		SELECT "Author_Add" FROM "Author_Add" ORDER BY "Author_Add" ASC				OnFocusGained	✔
	… comAut	Combo box		132,403	246,26		SELECT "LastName" \|\| ', ' \|\| "FirstName" AS "Name" FROM "Author" ORDER BY "Name" ASC				OnFocusGained	✔
	… combofields	Hidden control
	… GroupFrame	Group box	Author	37,370	505,216
	… lblAuthor	Fixed	Author	132,384	246,20
	… lblAuthorAdd	Fixed	Author Add	390,384	140,20
	… lblSort	Fixed	Sort	50,384	64,20
	… Navigationsleiste 1	Navigation bar		50,434	480,26
	… numSort	Numeric		50,403	64,26		Author_Sort					✔
	… Tablecontrol	Gridcontrol		50,466	478,108
	… … NumericField1	List box	Author				SELECT "LastName" \|\| IFNULL(', ' \|\| "FirstName", '') AS "Name", "ID" FROM "Author" ORDER BY "Name" ASC					✔
	… … NumericField2	Numeric	Author Sort.				Author_Sort					✔
	… … NumericField3	List box	Author Add				SELECT "Author_Add", "ID" FROM "Author_Add" ORDER BY "Author_Add" ASC					✔
	butMediaChart	Button	Media Chart	844,138	120,26	MainForm					OnActionPerformed
	butOK	Button	OK	264,97	33,26	MainForm				Refresh form
	Button 1	Button	Loan	37,18	102,25	Navigation					OnActionPerformed
	Button 10	Button	Author Add	566,648	77,27	Navigation					OnActionPerformed
	Button 2	Button	Recall	170,18	101,25	Navigation					OnActionPerformed
	Button 3	Button	Reader	302,18	101,25	Navigation					OnActionPerformed
	Button 4	Button	Media	434,18	102,25	Navigation
	Button 5	Button	Category	50,648	76,27	Navigation					OnActionPerformed
	Button 6	Button	Mediastyle	151,648	76,27	Navigation					OnActionPerformed
	Button 7	Button	Town	251,648	77,27	Navigation					OnActionPerformed
	Button 8	Button	Publisher	352,648	77,27	Navigation					OnActionPerformed
	Button 9	Button	Author	466,648	76,27	Navigation					OnActionPerformed
	combofields	Hidden control				MainForm
	comCat	Combo box		37,215	329,24	MainForm	SELECT "Category" \|\| IFNULL(' > ' \|\| "Description", '') AS "Cat" FROM "Category" ORDER BY "Cat" ASC				OnFocusGained	✔
	comMed	Combo box		377,215	270,24	MainForm	SELECT "Mediastyle" \|\| IFNULL(' > ' \|\| "Loantime", '') AS "Style" FROM "Mediastyle" ORDER BY "Style" ASC				OnFocusGained	✔
	comPub	Combo box		170,265	101,23	MainForm	SELECT "Publisher" FROM "Publisher" ORDER BY "Publisher" ASC				OnFocusGained	✔
	comTow	Combo box		37,264	113,24	MainForm	SELECT "Town" FROM "Town" ORDER BY "Town" ASC				OnFocusGained	✔
	fmtID	Formatted		37,159	101,25	MainForm	ID					✔	Standard
	fmtPrice	Formatted		592,264	56,24	MainForm	Price					✔	[$$-409]#.##0,00;[ROT]-[$$-409]#.##0,00
	fmtPub_Year	Formatted		289,265	73,23	MainForm	Pub_Year					✔	Standard
	GroupFrame	Group box	Table Maintenance	37,623	625,64	Navigation
	imgPicture	Image		680,264	152,152	MainForm	Picture					✔
	Labelfield 1	Fixed	Searchitem	37,79	215,20	Filter
	Labelfield 2	Fixed	Media - Input and Searching	37,56	323,20	Filter
	lblCategory	Fixed	Category > Description	37,196	241,20	MainForm
	lblComment	Fixed	Comment	170,296	125,19	MainForm
	lblEdition	Fixed	Edition	377,245	74,20	MainForm
	lblID	Fixed	ID	37,141	27,19	MainForm
	lblISBN	Fixed	ISBN/ISSN	37,296	115,19	MainForm
	lblMediastyle	Fixed	Mediastyle > Loantime [Days]	377,196	279,20	MainForm
	lblPicture	Fixed	Picture	680,245	152,20	MainForm
	lblPrice	Fixed	Price [$]	592,245	59,20	MainForm
	lblPub_Year	Fixed	Pub-Year	289,246	61,20	MainForm
	lblPublisher	Fixed	Publisher	170,246	81,20	MainForm
	lblTitle	Fixed	Title	149,141	40,19	MainForm
	lblTown	Fixed	Town	37,245	56,20	MainForm
	Navigationbar	Navigation bar		327,97	593,26	MainForm
	numISBN	Numeric		37,314	108,27	MainForm	ISBN
	Subtitle	Subform				MainForm	Subtitle (Table)	ID	Media_ID
	… Tablecontrol	Gridcontrol		554,434	429,152
	… … Length	Time	Length				Length					✔	24h short
	… … No	Formatted	No				No					✔	Standard
	… … Subtitle	Text	Subtitle				Subtitle					✔
	Textfield 1	Text		37,97	215,26	Filter	SearchItem					✔
	txtComment	Text		170,314	479,58	MainForm	Comment					✔
	txtEdition	Text		377,264	197,24	MainForm	Edition					✔
	txtISBN	Text		37,346	127,20	MainForm	ISBN_Test
	txtTitle	Text		149,159	350,25	MainForm	Title					✔
Reader_Admission	Button 1	Button	Loan	37,18	102,25	Navigation					OnActionPerformed
	Button 2	Button	Recall	170,18	101,25	Navigation					OnActionPerformed
	Button 3	Button	Reader	302,18	101,25	Navigation
	Button 4	Button	Media	434,18	102,25	Navigation					OnActionPerformed
	Button 5	Button	Street	50,648	76,27	Navigation					OnActionPerformed
	Button 6	Button	Postcode > Town	138,648	102,27	Navigation					OnActionPerformed
	Form	Subform				Filter	Reader_Input_Filter (Query)
	… Adress	Subform					Adress (Table)	ID	ID		OnApproveRowChange OnCursorMoved
	… … Combofield 1	Combo box		233,560	51,26		SELECT DISTINCT "Country" FROM "Adress" ORDER BY "Country" ASC
	… … combofields	Hidden control
	… … comPosTow	Combo box		302,560	158,26		SELECT "Postcode"."Postcode" \|\| ' ' \|\| "Town"."Town" AS "Pos_Tow" FROM "Postcode", "Town" WHERE "Postcode"."Town_ID" = "Town"."ID" ORDER BY "Postcode"."Postcode" ASC, "Town"."Town" ASC				OnFocusGained	✔
	… … comStr	Combo box		37,560	152,26		SELECT "Street" FROM "Street" ORDER BY "Street" ASC				OnFocusGained	✔
	… … Labelfield 1	Fixed	Street	37,535	152,26
	… … Labelfield 2	Fixed	No.	201,535	33,26
	… … Labelfield 3	Fixed	Country	233,535	57,26
	… … Labelfield 4	Fixed	Postcode and Town	302,535	158,26
	… … Textfield 1	Text		195,560	32,26		No					✔
	… Button 1	Button	OK	726,125	33,27					Refresh form
	… Labelfield 1	Fixed	Reader - Input	37,58	417,24
	… Schoolclass	Subform					rel_Reader_Schoolclass (Table)	ID	ID
	… … Labelfield 1	Fixed	Schoolclass	37,472	89,26
	… … Listfield 1	List box		37,497	83,26		SELECT "Grade"."Grade" \|\| ' ' \|\| "Class"."Class", "Schoolclass"."ID" FROM "Schoolclass", "Grade", "Class" WHERE "Schoolclass"."Grade_ID" = "Grade"."ID" AND "Schoolclass"."Class_ID" = "Class"."ID" ORDER BY "Grade"."Grade", "Class"."Class" ASC					✔
	… Tablecontrol	Gridcontrol		37,100	449,319
	… … FisrtName	Text	First Name				FirstName					✔
	… … ID	Formatted	ID				ID					✔	Standard
	… … LastName	Text	Last Name				LastName					✔
	… … Listfield 1	List box	Gender				SELECT "Gender", "ID" FROM "Gender" ORDER BY "Gender" ASC					✔
	… … Lock	Check box	Lock				Lock
	… Textfield 1	Text		37,434	442,26		Formheader
	Groupframe	Group box	Table Maintenance	37,623	209,64	Navigation
	Labelfield 1	Fixed	Filter (Last Name)	573,100	146,20	Filter
	Textfield 1	Text		569,125	146,27	Filter	Filter					✔
Recall	Button 1	Button	Loan	37,18	102,25	Navigation					OnActionPerformed
	Button 2	Button	Recall	170,18	101,25	Navigation
	Button 3	Button	Reader	302,18	101,25	Navigation					OnActionPerformed
	Button 4	Button	Media	434,18	102,25	Navigation					OnActionPerformed
	Button 5	Button	Print Recalls	251,207	127,33	Form					OnActionPerformed
	Form	Subform				Form	Media_Loan_Balance_Time_Recall (Query)	ID	Reader_ID
	… Form	Subform					Recall_Recallnumber (Query)	ID	Loan_ID
	… … Tablecontrol	Gridcontrol		226,609	291,89
	… … … DateField1	Date	Recall Date				Date					✔	Standard (short)
	… … … Numeric Field 1	Numeric	Recall No.				Recallnumber
	… Labelfield 1	Fixed	Medium:	37,578	89,26
	… Tablecontrol	Gridcontrol		37,300	713,261
	… … Loan_Date	Date	Loan Date				Loan_Date					✔	Standard (short)
	… … Media_ID	Text	Medium				ID_Title_Author					✔
	… … Numeric Field 1	Numeric	Extension				Extension
	… … Numeric Field 2	Formatted	Balance Time				BalanceTime						0 [$Days];[ROT]-0 [$Days]
	… … Textfield 1	Formatted	Loan Days				LoanDays						0 [$Days]
	… Textfield 1	Text		125,578	619,26		ID_Title_Author					✔
	Labelfield 1	Fixed	Recall for Reader	37,263	190,26	Form
	Navigationbar 1	Navigation bar		37,206	197,32	Form
	Tablecontrol	Gridcontrol		37,61	341,127	Form
	… TextField1	Text	First Name Reader			Form	FirstName					✔
	… TextField2	Text	Last Name Reader			Form	LastName					✔
	Textfield 1	Text		233,263	303,26	Form	Name