2 Replies Latest reply on Nov 16, 2015 12:41 PM by evansj2

    proper way to make a drop down list from a portal record

    evansj2

      All,

       

      I have a file that i have been working on that would link a user database with four others; trouble reporting, av projects, machine shop projects and account numbers.

       

      The account numbers are used on the two projects dbases and I would like them to show up as a drop down list. So I created a value list from the accounts dbase, and have it only include related values starting from the Users dbase.


      For the most part its working however intermittently i have seen some funky data (e.g. not a full list of accounts).


      Is there a best practice for this type of thing? Should i be doing it some other way?


      Any help would be greatly appreciated.

      Jim