Hi, James,

I have a question about the Stored Procedure setting in Lookup Rule for my Forms.

I create a SQL Server Database and a stored procedure to retrieval the Employee's profile form Job Evaluation purpose.

The form Lookup rule address is at http://itdlsffrmtst1/Forms/design/lookup/29#

My stored procedure looks like:

USE [KaneCountyEmpIDCard]
GO
/****** Object:  StoredProcedure [dbo].[usp_EmpIDCardsView]    Script Date: 12/2/2016 12:12:53 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- =============================================
ALTER PROCEDURE [dbo].[usp_EmpIDCardsView]
    -- Add the parameters for the stored procedure here
    @ManagerID as varchar (20)  

AS
BEGIN
    SET NOCOUNT ON;
    SELECT v.Manager_1, v.Department as [Group], v.EmployeeNumber, v.FirstName, v.MiddleName, v.LastName, v.PhoneNumber, v.EmailAddress,
            v.[OrgStructureDescConcatenated] as Department, isnull(v.[Manager], '') as Manager
    FROM vwIDCards v
    where v.[Manager_1] Like @ManagerID + '%'  
END

I tested for the stored procedures in SQL Server , it works perfect.

However, in the Forms Lookup Rule, although the parameter @ManagerID shows up, I didn't see any of  the fill section values in " with result set column" 

Does that caused by the data source setting authorization? Or any other reasons?  Please help!

Thanks!

Helen