4 Replies Latest reply on Mar 11, 2013 10:42 AM by philmodjunk

    Best Strategy for Multiple Form References to a Related Field ID?

    DeanChristiansen

      Title

      Best Strategy for Multiple Form References to a Related Field ID?

      Post

           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.

           Any suggestions?