5 Replies Latest reply on Jul 6, 2017 8:44 AM by HeidiStewart

    Conditional Value List

    HeidiStewart

      i've read through a few other posts on this topic, but can't seem to relate it to my database.

       

      I'm trying (haha) to create a database to track expenses. 

      Table 1: Object Codes

      fields include : Object Type (drop down from a custom value list)

                        Object Code (5 digit #)

                        Object description (example: accommodation)

       

      Table 2: Expenses

      fields include: Object Type (drop down from a custom value list)

                      Object Code (drop down from a value list that should only show codes associated with the type chosen above)

       

      Each of the Object Types have numerous (5-50) Object Codes associated with it.

       

      I have linked my Expenses and Object Codes tables.

       

      What i'm trying to do, is when I create a new expense and I select an Object Type I want the drop down Object Code field to only show the codes associated with the type I just chose. 

       

      Right now I can get ALL the codes, or none of the codes.  I'm not sure there is a very simple fix, but I can't seem to find it.