Add the ability to have custom field do a look up to a table. For example, look up to employee table to add employees to a custom field.

by: Tim H. | over a year ago | Other

Comments

• This can be done with the [SELECT FROM WHERE] function. Create a calculated field. For example, if your report is a purchase order and has an employee number but you want it to say their last name, you can say [SELECT employ.lstnme FROM employ WHERE employ.recnum={pchord.odrdby}]

  by: Ryan B. | over a year ago