The following article is an example of how to have fields depend on each other. This example has you configure two fields: a field displaying available locations, and a field displaying available bins within the first field’s chosen location. For your use, modify the example data with your data.

1. Navigate to Test Templates in Business Central.
2. Select +New and modify the following fields:
   • Code: LOOKUPEXAMPLE
   • Description: lookup example
3. Select Add Field(s) To This Template and select Next.
4. Input the following:
   • Description: location
   • What type of data is it? : A choice from a list
5. Select Next.
6. Enable An existing table.
7. Modify the following fields as needed:
   • Which Table?: Location
   • Which Field?: Code
   • Any Filter?: Code / SILVER|WHITE, and select OK.
8. Select Finish.
9. Select Add Field(s) To This Template and select Next.
10. Input the following:
    • Description: Bin
    • What type of data is it? : A choice from a list
11. Select Next.
12. Enable An existing table.
13. Modify the following fields as needed:
    • Which Table?: Bin
    • Which Field?: Code
    • Any Filter?: Location Code / [location], and select OK
14. Select Finish.
15. Select Test Generation Rules.
16. Select an option in the Table
17. Select the back arrow, select Create Test, and modify the following fields:
    • Source: ITEMLDGEROUTTOTEST
    • Choose Record: L240823901AM, and select OK
18. Select OK.
19. Select the … button for LOCATION’s Test Value field, select the required value, and select OK.
20. Select the … button for BIN’s Test Value field, select the required value, and select OK.

That is how you configure your fields to map to each other.

Check your mapped fields

1. Navigate to Quality Inspector Fields in Business Central.
2. Select Filter list by: / +Filter… / Code and input “location|bin”.

The Which Field? Specifies “Code”. The Any Filter? Field specifies the [location].