Solved

In a form, how do i display a range of choices in a field based on the choices made in a previous field

  • 11 October 2023
  • 1 reply
  • 110 views

Userlevel 1
Badge +4

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

icon

Best answer by AnthonyD 13 October 2023, 02:02

View original

1 reply

Userlevel 2
Badge +6

Hello @gsol ,

If you use the data source control, you can use the data source filter to restrict the records returned in the child returns.
 

Please let me know if you need more directions?

thanks,

Anthony

Reply