Choose Search Fields
Scroll through the list of field names and click to check or
uncheck the boxes next to the field names to select or deselect
them. You can change the order in which the fields will appear on
the search form by clicking on the field you wish to move and using
the up and down arrow buttons below the listbox to move it higher
or lower in the list.
Microsoft Access
Databases Only: Any field that is of type "memo"
in your database will automatically get generated on all forms as a
larger textarea box. Any field that is of type "boolean" in your
database will automatically get generated as a checkbox. If you
desire textarea boxes or checkboxes on your forms, it is
recommended you go into your database and make the fields of type
memo or boolean accordingly.
MySQL Databases Only: You will need to specify which
fields are of type memo and checkbox (boolean) later, on a screen
that is specific to MySQL databases.
Choose Report Fields
Choose the fields in the same way as above for the Reports (aka
Search Results Page).
This generated page looks like a report with one column across for each field and one row for each record (like a spreadsheet with rows and columns).
Choose Detail FieldsNOTE: If you have a unique
key that is of the AutoNumber type, it will not appear on the Add
or Edit pages. This is a precaution to avoid database errors. If a
field is of type AutoNumber, the number is generated automatically
by the database and should attempts should never be made to supply
them from the Add or Edit forms.