From a customer
We have a UDT for Sales Rep Quotes that uses the slpcode from OSLP file.
I know that I can go directly from the Sales Employee/Buyer table to filter the data to a single user using the foreign key field, but I would like to display the sales rep name/code in a dropdown instead of having to display the slpcode. The end users would be able to see sales rep names when choosing from the dropdown, but it would populate with the slpcode into the field. It would be great if it could show the description in both the dropdown and the field, but store the value, but I know that might not be easily coded.
Please sign in to leave a comment.