Hello,

I was working on implement the sequential incrementing number on LF forms and I follow the help file from this link http://www.laserfiche.com/support/webhelp/laserficheforms/9.2/en-us/forms/#LookupRules.htm?Highlight=increment

First I was not able to execute the sorted procedure getting the error "the column value don't exist " I replaced the values with [OrderNumber] and stored procedure now is:

USE [Forms]

GO

       SET ANSI_NULLS ON

       GO

       SET QUOTED_IDENTIFIER ON

       GO

       CREATE PROCEDURE [dbo].[sp_increment]

       AS

       BEGIN

       Declare @myvalue int

       select @myvalue= [OrderNumber] from dbo.OrderNumber where name = 'access'

       update dbo.OrderNumber set [OrderNumber] = @myvalue + 1 where name = 'access'

       Declare @myTable table

       (

       [param1] nvarchar(50)

       )

       INSERT INTO @myTable ([param1]) values ('@myvalue')

       select top 1 * from @mytable

       END

after that I connected the field look up rule with stored procedure when I open the from the field is populated with @myvalue.

Can anyone check this and let me know what I'm doing wrong.

Thank in advance for your help.