How to use InfoFind's Database List Form

Opening Database Forms

You can access database forms from the menu [Database]->[Database Applications]. Any form that you have created will show up as a link on the Database Applications form. If no database forms are saved on your computer then you will be prompted to create sample applications that you can use.

Database List Form

This form displays a list of database records and allows you to quickly filter the records with controls at the top of the form. To filter records select the field(s) that you want to filter, how you want to filter them, type the filter, and the click the [Filter] button. To create an Excel report of all displayed records click on the [Excel] button in the toolbar. If the list is linked to an entry form you can click on an individual record to edit it or see all fields.

InfoFind Database List Form

Editing the Form

To change the layout of the form click the [Design Form] button from the toolbar. You can then select new properties for the list form.

InfoFind Database List Form Properties

This section requires some knowledge of how databases work and understanding of common database terminology.
Form Properties
ApplicationName of the Application so that Forms can be displayed grouped by Application from the Database Applications Form.
TitleTitle of the Specific Form. Each Form must have a unique Application and Title.
Connection TypeType of Database Connection.
ConnectionDatabase Connection String. Click the […] button to define the string.
Db TypeThe type of Database (Database Vendor) for the Form’s Database.
GradientIf checked then a Gradient will be displayed for the Form’s background.
Table/ViewTable, View, or Query in the Database where the data is displayed from.
FieldsFields that will show in the list when the records are displayed. You can select fields from a list by first selecting a Table or View and then clicking the […] button.
Field TypesData type for each field. This allows data to be formatted in specific formats. To use this feature first select the fields and then click the […] button to select the data types.
CriteriaThis field allows you to specific a SQL WHERE clause to control what data is first displayed.
Order ByThis field allows you to specific a SQL ORDER BY clause to control how data is first sorted.
Link FormThe Link Form is the Entry Form that will be displayed when you click on a record.
Link FieldLink Field is used with Link Form and will determine what field is used to display the record. This property should be filled in with the primary key or a unique value.