Hi,

In forms 10 I use the forms lookup to retrieve values from a database based on three pre-filled fields and the results fill a table as per the number of records. In this case there will be an Autofill button. Now supposing the records in the database are in the thousands, I would not be able to lookup all of them at once. Is there a possibility  of retrieving a range of values, Let's say 20 records at a time or preferably selecting the range you want to retrieve? I have created a stored procedure that can bring up the values based on the four prefilled fields and the range I want, but I do not seem to know how I can fit it into the Lookup page of the form since when I use it the "as new rows" checkbox gets disabled. When I run it it retrieves the data but does not create the row. 

I have attached herein my what I am currently using. Any suggestions will be highly appreciated 

Mark