Skip to content

Quality Inspector · Set up

Restrict a Field’s Choices Using Another Field Using Quality Inspector

Last updated September 22, 2025

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].

View this article as Markdown

Still need help?

Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.