Relationship between two Combobox in Access

Asked

Viewed 18 times

0

I’m trying to relate 2 Comboboxes in Acess, but I can’t find how to do it.

inserir a descrição da imagem aqui

This is my form, I would like when selecting the value in the field "Expense Type", the values of the field below, "Expense", to be related to the field "Expense Type":

inserir a descrição da imagem aqui

For example, when selecting "FIXED" in the "Expense type", the values available in the "Expense" field are only "FIXED" and if I select "VARIABLE", the list of the "Expense" field would change to the related values.

inserir a descrição da imagem aqui

Currently this list is appearing in both cases, "FIXED" or "VARIABLE", but I would like to do it in some conditional way, so that depending on the value selected in "Expense type" your respective list appears in the field below.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.