Field References Sorted by Field Name

This powerful report shows where and how each field is defined or referenced across the entire database. Knowing where your fields are used is certainly important before changing them.

In this example, the data is sorted by field name (Address, Birth Date, CategoryID). Within each grouping, you can see where the field is used. For instance, the Address field is used in a Query named Invoices, which is used by a control in the Invoice Report.

The data shown here is similar to the Table References, Sorted by Table Name, but it's sorted by Field Name to show all the tables where identically named fields are used. This is a great tool for verifying consistency of field definitions. A good programming practice is to make sure identically named fields are defined the same way (same data type, data size, and description)

NOTES

• The Resolved? column shows whether the field reference is valid (if an object references a field that no longer exists, that's flagged as an error and appears in the Error reports).

• If your module code references a field name with a variable, it's listed here and the Variable? column is checked.