2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Managing Database Records
Managing an OmniForm Database - 216
• To link individual fields, select a field on the left, select its
corresponding field on the right, and click
Link
.
• Click
Auto
to automatically link all fields with the same name.
Some fields will not have matching names but contain the
same information. Or, you may not want to import all fields.
Linked fields appear in the
Links
list box.
• Select a link in the
Links
list box and click
Unlink
to unlink it.
• Click
Unlink All
to unlink all fields.
•Select
Recalculate Imported Records According to Form’s
Calculations
when it is selectable to apply existing calculations
to the imported records.
9 Click
Range...
to open the Record Range dialog box to specify a
range of records to import.
Otherwise, OmniForm imports all records by default.
• Type the first record number to import in the
From
text box and
the last record number of the range to import in the
To
text box.
• Click
OK
to return to the Import dialog box.
10 Click
OK
when you are done linking fields.
OmniForm imports the information into the selected fields,
creating as many new records as necessary in the process.
11 Click
OK
in the dialog box that tells you how many records
were imported successfully.