A view won't work as I have 3 related tables, with 2 of the related tables relating directly to the parent table.

I don't understand why my index based on a UDF isn't working. Any ideas. This is the code for one of the stored procedure UDFs:

FUNCTION getcompname
PARAMETERS xcCompanyID
PRIVATE lcCurAlias, lcCompanyID, lcCompany

lcCurAlias = ALIAS()
lcCompanyID = ALLTRIM(xcCompanyID)
lcCompany = " "
IF !EMPTY(lcCompanyID)
IF !USED("FindCompany")
USE Company IN 0 AGAIN ALIAS FindCompany
ENDIF
IF SEEK(lcCompanyID, "FindCompany", "Company")
lcCompany = FindCompany.Name
ENDIF
ENDIF
IF USED("FindCompany")
USE IN FindCompany
ENDIF

SELECT (lcCurAlias)
RETURN lcCompany