AnsweredAssumed Answered

Conditional Value List

Question asked by HeidiStewart on Jul 5, 2017
Latest reply on Jul 6, 2017 by 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.

Outcomes