You are viewing limited content. For full access, please sign in.

Question

Lookup Rules

Forms Laserfiche

Updated March 10

asked on March 10 • Show version history

Hello,

I have a form and trying to do lookup rules by using SQL(Stored Procedure) and I don't understand how to get populate on my form so please show me a great example(with screenshots) on how to use lookup rules using Stored Procedure only please??

Thank You

Lookup Rules Example.png (52.79 KB)

| Download

0 0

Replies

replied on March 10

In addition to the other suggestions, you should also make sure your SQL connection profile has the necessary permissions to execute stored procedures.

On their own, read-only permissions do not allow users to execute stored procedures.

2 0

replied on March 10

Your setup looks correct. Did you verify the USE field value in the form matches the parameter setup in your Stored Procedure to pull a row?

0 0

replied on March 10

Donovan,

I agree with Angela that the setup looks correct. I would also add to make sure that the column names that the stored procedure result set returns are typed in exactly as they appear when you run the stored procedure from SSMS. As you have found out Forms does not automatically pull column names from stored procedures for you to select to populate the fields, you have to manually type them in.

0 0

You are not allowed to follow up in this post.

Question

Question

Lookup Rules

Replies

Sign in to reply to this post.