AnsweredAssumed Answered

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

Question asked by DeanChristiansen on Mar 9, 2013
Latest reply on Mar 11, 2013 by philmodjunk

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? 

      

      

      

Outcomes