Conditional Drop Down Set Up

One way to do this:

Say the [Payee] field is located in the "Payments" table.

You'll need a relationship from your Vendors table to the Payments table - "Vendors" would be the parent table.

Relationship:  1 Vendors has many Payments

From that Vendors table - you'll have the [Related Vendor] field, and a reference proxy field such as [Vendor Name].

So on the Payments form - you add a dynamic form rule

If [Payee] is equal to the value "Vendor"

Show [Vendor Name].

This displays the [Vendor Name] dropdown when [Payee] = "Vendor", otherwise it hides it.

So if [Payee] = "Client" - you're done.  [Vendor Name] remains blank.

If [Payee] = "Vendor", then you can select from the [Vendor Name] dropdown.

Can we have a conditional drop down from within the same table?

You would have to describe your situation with a little more detail.

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.

You would either have to do that with a form rule, which obviously only works in forms, and not grid edit, or else just make the second field to be a pure formula field based off the data entry in the first field.

Thanks. Could you kindly give me an example of form rules?

if there is a one for one relationship between Development type and Development Type,  make a table for the choices even though it would be a small table with only three records in it. And then I would have a relationship  and pull in both the development type in the development code from that table.

 And alternative would be a hard coded formula to calculate the value of the development code but I don't think it's good practice to do that become because it becomes very obscure how one would add a new drop down choice.

 I would not recommend using for rules because they don't working grid edit.

 But having said all that and example of a formal role would be this
When development type equals Choice 1
Change the value of development code to Code1

Many thanks for your help.

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.

You will need to have a table for the choices for the Development Code. However, you will not need to have a field for the Development Tyoe. That can be a simple multiple choice field.