So here’s my problem: i have two fields, one named Family and another, subfamiliy.

I want the choices available in subfamily to be displayed based on the choices made in the Family field.

You can select from 4 differents families, where each one has a specific familiy code.

So if you were to select in the family field “AAA - Value 1”, the only choices appearing in the subfamily field would be A01 - Item 01, A02 - Item 02 and A03 - Item 03.

Both of those fields are data lookups from two different sharepoint lists.

Does anyone have a suggestion as to how i could manage this?

Thanks