I am trying to link through several tables and them several records to find a field that matches the criteria.
I am getting a syntax error and cannot figure out why. Can anyone help me please ?
display smmEmplId fgt_psm_emplId()
WHILE SELECT smmResponsibilitiesEmplTable where smmResponsibilitiesEmplTable.ResponsibilityId == “Development Officer” &&
smmResponsibilitiesEmplTable.RefRecId == smmOpportunityTable.RecId &&
smmOpportunityTable.OpportunityId == SalesQuotationTable.OpportunityId
EmplId = emplId