Jump to content
  • 0

Using a View for a dropdown lookup



I've got a problem. In one DataPage, there is a field called "Received By". This is a dropdown, and it is using a view to lookup the data. 

On the next DataPage, "Received By" displays numbers and not the name. 

I would use a table, but here is the problem. We have an employee table with over 100 employees recorded in it. We are using a view to cut that number down to only the employees in the Receiving Department. If I set the lookup from Received By to the employee table, I think this would work, but the users would have over 100 names to scroll through. 

I believe the number that is being displayed is the employee id number from the employee table. It's getting the data value that was inserted to the record but cannot connect that with the display value.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0


I think you have configured the dropdown to display the employee id instead of the name.

For the below example, I set the "Field for display" the exact field that I want to see in the dropdown menu. In your case, check what field did you set for display. If you set the employee id as the field for  display, then simply change it to the employee name field.


I hope this helps. Thank you!

Link to comment
Share on other sites

  • 0

Hey, @HampasLOUpa. The problem I am having is on the results page of a tabular search and report. The records in the results page are where the problem persists. It should be display only, so there is no Lookup Table to mess with. This is purely for reporting and no editing should take place in this page. All I want is to pull up information from previous records and display it. Everything is working except for this field, that is why I am so confused.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...