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

Discussion

Discussion

Forms Lookup fields

Forms
Updated April 6, 2020
posted on April 3, 2020

I wanted to look up the result of code , when project code = selected project and description = selected description matches the value. 

For example if user select project code = HAN0027-042020 and description = Floorboard, so it must show WUD1022 as the value of code field. 

I have set lookup rules as shown below. The result based on my lookup setup is showing empty code value. Kindly advise. 

 

 

Thank you, 

0 0
replied on April 4, 2020

Hi Viknes,

Execute the script on the management studio and see if you got the expected results.

E.g.

Select code from View_1 where description = 'Floorboard' and project_code = 'HAN0027-042020'

It should provide you with the result, and this will make sure that you've correctly define your lookup rules.

Also, I would suggest that instead of using a View, maybe you can use a StoreProcedure to accomplish this lookup. This will prevent in having several lookup rules.

Thanks.

 

Regards,

Mahesh.

3 0
replied on April 6, 2020

How would a stored procedure prevent multiple lookup rules? The screenshot indicates they're using dropdown fields in a table and filling in the possible description values based on which project code is selected.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...