Stump the Panel

Paul Grenier, Lead Moderator

Stump the Panel » End Users and Information Workers

1. 

   pjcolbeck
   Member

   By default, the pulldown menu for lookup columns features the values for the lookup field found in the referenced list. I would like to add descriptive information to the pulldown menu for a lookup column.

   Example:
   I have the following chart of accounts list:
   Account # Account Description
   1000 Travel Expenses
   2000 Taxes

   When I lookup the Account # in other lists, I would like to show the following values in the dropdown list:
   1000-Travel Expenses
   2000-Taxes

   Once selected, I would like for simply the account # value to be entered (e.g. "1000") not the whole pulldown description.

   Any thoughts as to how to achieve this?
   Curious,
   Pat

   Posted 1 week ago #
2. 

   AutoSponge
   Administrator

   I think this would need to be a custom form/control (you can modify the drop down control in SPD but this "breaks" the form).

   You can also add the descriptions after the page loads with javascript. This would be harder to do because SPD can't help you, but the result would not "break" the form (meaning, changes to the list would appear in the form correctly).

   Posted 1 week ago #

RSS feed for this topic

Reply

You must log in to post.