ADDFIRM2

Returns specified field from the Firms table based on the Firm ID.

Reporting Area(s)

Course, Instructor, Names

Required Parameters

1. Firm ID (i.e.nmfmid, infmid, cofmid)
2. Field from Firm Table to return (i.e. "fmcity", "fmextra", "fmcontact")

Optional Parameters

None

Example(s)

ADDFIRM2(infmid,"fmcity") returns city of the instructor's firm

Notes

Firm ID (nmfmid, infmid, cofmid) must be present in the cursor.

This function will converts all returned values to character format.

Related Functions

ADDFIRM