For offices coming from Lotus Approach:
- A report can cover the records found in Browse, and new reports start that way. Find
the records in Browse, then open the report. It says which records it covers, or that nothing
was found and it covers every record
- Find again opens Find with the last find of the table, to change it or run it again.
Press Ctrl+Shift+F in Browse, or give a button the step Find again
- A macro can run from a function key in Browse of its table: F2, F3, F4, F6, F8, F9 or
F12. The key is kept in the file, so everybody in the office has the same keys
- A new step, Open a table, opens any table of the database on a form you choose, with
every record or a saved find, whatever app the table is in
- Show related records can open the records on a form you choose, such as a customer's
contacts on the contact form. The form designer adds such a button in one click
- A field of a related table, such as the customer's name on an order, can be placed on
a form like any other field. It shows the related record's value, prints, and can be searched
in Find. It cannot be typed into
- A field can be read only on one form. A button's step can still change it
- In the form designer, several items can be chosen at once with Shift or Ctrl and a click,
a rectangle, or Ctrl+A. They can be moved, deleted, lined up, made the same size and spaced
evenly, and a setting changed for one changes for all
- The sheet scrolls by itself while you drag an item near its edge
- A label on the left can be as wide as its words and two spaces. New fields start this
way, and forms made before keep their look. Line up the boxes gives the chosen fields one
label width, so the boxes start in one column
- A new field type, Currency: an exact amount shown with a symbol, before or after it,
with the places you choose, and with a minus sign or brackets for a negative amount. Typing
and Find take the symbol and the separators of your region. Money columns from dBase and
Access arrive as Currency
- A crosstab can show up to four totals in each cell, such as the sum of the amount and
the count of orders. Each one shows at every level, in every subtotal and in the totals
- A field's list of values can come from a table. One lookup table can hold many lists,
with a column that names the list, so a value added there is offered everywhere. Only these
values makes the list strict
- More room for the form: in Browse the header is one line, and less-used buttons are under
More. Ctrl+Shift+H hides the header and the record bar, and Esc brings them back. On the
Reports screen and in Preview, Show only the pages gives the pages the window. F11 is full
screen on Windows and Linux; on a Mac, use the window's own full screen
Also in this release:
- On a form, a calculated field, and a field your role may only read, look read only, with
a lock that says why
- With the header hidden, a thin line still says which records are shown
- A large lookup table no longer slows down opening the table that uses it, or saving many
records at once
- A computer on 1.7.0 says its version when it signs in. A computer on 1.6.0 or earlier
is sent a message in place of each new step, and text in place of each related field. When
that computer saves, the host keeps them. Related fields, Currency, lists from a table, several
totals and the new steps need the computer that holds the database to run 1.7.0 or later,
and so does an app template that holds them
