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.