using a field to choose a value list
OK, So i have a database that has 2 parts to it. I have an account code (2,3,5,6) and account number ( a five digit number) and an account subcode (a 4 digit number). I want a specific value list to show when the account code is one thing and a specific value list to show when the account number is something else. So, if the account code is 2, then it will use the account numbers for 2 accounts value list. Any ideas??