Best Strategy for Multiple Form References to a Related Field ID?
Thanks in advance for any help.
I have a form, where I'm using 15 separate drop-down lists to set ContactID's (the number) in 15 different fields. Said differently, I'm using the drop-down lists to store the ID number, not the name of each individual, sourced from a Contacts table. However, I'd like each field on the form to display a concatonated name in the format 'Last, First, MI', with the arrow of the drop-down list next to the name display.