Hi @ican
To achieve this in, you can utilize a Choice List field type for both "Fruit Choice Field" and "Vegetable Choice Field" on your form. You would then associate each Choice List field with its respective Choice Table (u_custom_choice), filtering the choices based on the 'Type' column in the u_custom_choice table.
Here's a step-by-step guide on how to set this up:
1. **Create the Choice Table (u_custom_choice):**
- Create a new table named "u_custom_choice" with the following fields:
- Name: Text field to store the name of the fruit or vegetable.
- Type: Choice field to specify whether it's a fruit or vegetable.
2. **Populate the Choice Table:**
- Populate the "u_custom_choice" table with entries for fruits and vegetables, specifying the appropriate type for each entry.
3. **Modify the Form:**
- Edit the form where you want to display the "Fruit Choice Field" and "Vegetable Choice Field".
4. **Add Choice List Fields:**
- Add a Choice List field for "Fruit Choice Field" and "Vegetable Choice Field".
- For each field, set the 'Choice Table' to "u_custom_choice".
- Apply a filter to each field to display only fruits for the "Fruit Choice Field" and only vegetables for the "Vegetable Choice Field".
5. **Apply Filters:**
- For the "Fruit Choice Field":
- Create a filter condition to show only entries from "u_custom_choice" where Type is 'Fruit'.
- For the "Vegetable Choice Field":
- Create a filter condition to show only entries from "u_custom_choice" where Type is 'Vegetable'.
6. **Save and Test:**
- Save your changes to the form and test it to ensure that the correct choices are displayed based on the type (fruit or vegetable) selected.
By setting up Choice List fields and associating them with the "u_custom_choice" table while applying filters based on the 'Type' column, you can achieve the desired behavior of displaying fruit choices in the "Fruit Choice Field" and vegetable choices in the "Vegetable Choice Field".
Do give a thumbs up if this works for you.
Regards,
Akshay
