Table of contents
Example_Combobox_Listfield

• Tables
  • name
  • postcode
  • street
  • town
• Queries
  • address_complete
• Forms
  • name
  • name_correlated_subquery
  • name_tablecontrol
  • readme
• Modules
  • Comboboxes
• Index

List of fields by table

Table name	Field name	Field type	Primary key	Index #01	Index #02	% not Null	Most positive	Longest string
name	firstname	VARCHAR				100		6
	ID	INTEGER	✔			100	5
	lastname	VARCHAR				100		9
	number	VARCHAR				100		4
	postcode_ID	INTEGER			ASC	100	8
	street_ID	INTEGER		ASC		100	4
postcode	ID	INTEGER	✔			100	8
	postcode	VARCHAR				100		8
	town_ID	INTEGER		ASC		100	8
street	ID	INTEGER	✔			100	4
	street	VARCHAR				100		12
town	ID	INTEGER	✔			100	8
	town	VARCHAR				100		11