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.
- Navigate to Test Templates in Business Central.
- Select +New and modify the following fields:
- Code: LOOKUPEXAMPLE
- Description: lookup example
- Select Add Field(s) To This Template and select Next.
- Input the following:
- Description: location
- What type of data is it? : A choice from a list
- Select Next.
- Enable An existing table.
- Modify the following fields as needed:
- Which Table?: Location
- Which Field?: Code
- Any Filter?: Code / SILVER|WHITE, and select OK.
- Select Finish.
- Select Add Field(s) To This Template and select Next.
- Input the following:
- Description: Bin
- What type of data is it? : A choice from a list
- Select Next.
- Enable An existing table.
- Modify the following fields as needed:
- Which Table?: Bin
- Which Field?: Code
- Any Filter?: Location Code / [location], and select OK
- Select Finish.
- Select Test Generation Rules.
- Select an option in the Table
- Select the back arrow, select Create Test, and modify the following fields:
- Source: ITEMLDGEROUTTOTEST
- Choose Record: L240823901AM, and select OK
- Select OK.
- Select the … button for LOCATION’s Test Value field, select the required value, and select OK.
- 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
- Navigate to Quality Inspector Fields in Business Central.
- Select Filter list by: / +Filter… / Code and input “location|bin”.
The Which Field? Specifies “Code”. The Any Filter? Field specifies the [location].
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.