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

Question

How to use a Stored procedure to populate drop downs based on other Input fields

Forms How To

Updated July 20, 2017

asked on July 20, 2017 • Show version history

I'm having trouble understanding how stored procedures function in LF Forms.
I have 2 input fields that a user should be able to use to search through a dropdown with filtered results.

Do the input fields have to match exactly?

Unit example.PNG (5.5 KB)

| Download

Stored procedure Example.PNG (21.93 KB)

| Download

0 0

Replies

replied on July 20, 2017 • Show version history

It depends on how your stored procedure is designed. If you don't want the input fields to match exactly with data in db, you could use pattern matching in search conditions in stored procedure. Forms just calls the stored procedure with certain parameters and gets returned data.

Reference: https://technet.microsoft.com/en-us/library/ms187489(v=sql.105).aspx

1 0

You are not allowed to follow up in this post.

Question

Question

How to use a Stored procedure to populate drop downs based on other Input fields

Replies

Sign in to reply to this post.