This article will show you how to find Available Fields in Report Designer (RD), and it will also explain how to find the Key and Primary keys you would use when building a Lookup formula for a report or Inquiry.

Print the available fields from Report Designer

1. Start Report Designer.
2. Select Tools, Available Fields.
3. Under Records Available, select each record for which you want to view available fields, then click OK.
4. If you want to include ODBC information, mark the Include Information for ODBC Reporting? check box.
5. Click Print Preview to view the report on the screen, or click Start to print the report to a printer.

At the end of each record listing, under Standard Orders, the Keys to the record are listed.

• These are the fields that uniquely identify one record in the database.
• The first Key listed is the Primary Key. 
• Keys are made up of one field or several fields, which are listed in parentheses under the key name.  
• Knowing the key fields can be useful when you use the LOOKUP function in Report Designer.

TIPS:

• If you marked Include Information for ODBC Reporting, when the report says "not ODBC creatable" or "ODBC creatable", it is referring to that entire record/table.
• If there are individual fields that are ODBC editable/changeable, there will be an "X" under the Replaceable column next to the field.