Conditional Drop Down Set Up
I'm triyng to create a drop down that will do one of two things. The Field is named Payee. The two options in this drop down field are "Client" and "Vendor". If the Payee is Client, the process st...
Forum Discussion
Mark
Fairly a long time since I asked the question. As you are familiar with my set up, I would like to restrict the choices in a field based on another field. So do I need to establish separate tables. In this case you might wish to read my following earlier note:
"I have field Development Type, which has three values to choose from. These are long descriptions. Then I have a Development Code field in the same table. These are two letter codes corresponding to Dev Type. For example, a refurbishment is always known as RR and extension is RE. What I want the user is to select the dev type and the dev code shows the right code for that. In MS Access, I could achieve it without having to save a table.
Fairly a long time since I asked the question. As you are familiar with my set up, I would like to restrict the choices in a field based on another field. So do I need to establish separate tables. In this case you might wish to read my following earlier note:
"I have field Development Type, which has three values to choose from. These are long descriptions. Then I have a Development Code field in the same table. These are two letter codes corresponding to Dev Type. For example, a refurbishment is always known as RR and extension is RE. What I want the user is to select the dev type and the dev code shows the right code for that. In MS Access, I could achieve it without having to save a table.