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

Question

Posted to Government

Question

Stored Procedure setting in Lookup Rule for my Forms. And make the drop list show only one employees profile

asked on December 20, 2016

I created a multi pages form. At the Laserfiche form,  I used the SQL Server Database Stored Procedure as the data source.  And the employee ID is the primary Key in the table.  and the ManagerID is the Parameter of the stored procedures.  The concept is set the ManagerID as Manager's first name, when give the manager's first name as parameter asked ,  the drop list show this manager 's name ans his  position,  this part works well.  The in the Employee ID drop list choose one of the employee's ID, Then under the employee profile, it should show only this personal profile.  However, It is not work well at this steps.  I set up the Employee ID as Primary Key in the table.  It supposes choose one of the employees ID should show only that employees profile. However, It show the whole list of this Manager's employees profile  at the forllowing fields. How can I make it only shoiw the Employees profile with its Employee ID?

Thanks! Helen

0 0

Replies

replied on December 20, 2016

Hi Helen,

It sounds as if you should be able to do this.   Can you show a screen shot of your Lookup rules and form?
Not entirely clear on how you have it setup.

0 0
replied on December 21, 2016 Show version history

I created a stored procedures at the SQL database. and retrieval the employees profile from this stored procedures.  It has one parameters as ManagerID, that retrieval one of the manager's name and position.  Then  show the drop down menu to choose a employee's profile ID ( as emp_id) , suppose when choose a  emp_id,  there should be only one employees profile retrieved for following each names and email fields when click the fields.  Actually the emp_id is not work out for the single records.  Attached is my form design and lookup rule screen shots. any suggestions to fix this issue please let me know. If you need more details please email me. I will email you my queries. Thanks!

0 0
replied on December 22, 2016

What are the fields in your database table(s)?   I am no sql expert but it would seem you would need at least 2 tables ( manager and employee ) and 2 queries to accomplish what you are trying to do.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.