Functions Reference

Appendix A
|
Glossary 229
R
Read-Only Access privilege set
One of the three pre-defined privilege sets that appear in every file. The Read-Only
Access privilege set allows read access to the records in a file, but not write or design
access.
Record
One set of fields in a database table. Each record contains data about a single activity,
individual, subject, or transaction.
Recursive script
A script that calls itself.
Related field
For relational databases, a field in one table that is related to a field in another table (or to
a different field within the same table). If a relationship is defined between two tables
(even through another table), data in fields in one table can be accessed from the other
table.
Related record
A record in the related table whose match field (according to the relationship used)
contains a value that's equal to the value in the match field of another table.
Related table
For relational databases, the table that contains the data you want to access and work
with in the current table. For lookups, the table that contains the data to copy.
Relational database
A group of one or more database files that, when used together, contain all the data you
need. Each occurrence of data is stored in only one table at a time, but can be accessed
in any table, either in the same file or from a related file. Data from another table or file is
displayed in the current table without being copied, and the data changes whenever the
values in the other table or file change.
Relationship
Relationships provide access to data from one table to another. Relationships can join
one record in one table to one record in another table, one record to many other records,
or all records in one table to all records in another table, depending on the criteria you
specify when you create the relationship in the relationships graph.
Relationships graph
In the Relationships tab of the Manage Database dialog box, you can see the occurrences
of tables both in the current file and from any external, related database files. In this
relationships graph, you join tables and change relationships between fields in different
tables.