Reference Qualifier - How to return no rows when dependent field is empty

[kani1]

Hi,

I have 3 fields on the form

1) Category

2) Tier 1

3) Tier 2

Tier 1 is dependent on Category and Tier 2 is dependent on Tier 1.

I implemented a simple reference qualifier which works fine. Only issue that if Category is null (On form load during insert), Tier 1 returns all the rows. Is there a way to restrict not to return any rows for Tier 1 when Category is empty. Please provide some insights on this.

[zica]

Samuthirakani Ramalingam

Right Click on Tier 1 field, then Dictionary, then on Dependend Field tab,

Use dependent field = true

Dependent on field = category

Same for Tier 2

Use dependent field = true

Dependent on field = tier 1

Kind regards,

ZA

Do not feel shy to mark correct or helpful answer if it helps or is correct

[kani1]

Hi AKb,

could you please elaborate more on this? I am sorry I couldnt follow what you suggest

in my case,

category - references table 1

tier 1 - references table 2 ( there is a reference field to table 1 - service_area is the field name)

do you mean,

for tier1, you want me to add like

category=true^service_area=category

[zica]

I am sorry for the quick response.

I understood that when you open the form, you don't want to show the tier1 values if category is not chosen and tier2 values if tier1 is still empty, is that right?

Open you form with category, tier1 and tier2 fields.

On tier 1 Label, right click on the label, and you will get as following :

Click on personalize Dictionary. a new form will open, then you will have as below :

under the dependent tab (second tab), check the 'Use dependent field' and select 'Category'. That means that the 'Tier1' field depends on the category field.

Repeat the same action but now on the Tier 2 Field. For that one, select Tier 1 on dependent field (instead of category)

Let me know if you need more help

Kind regards,

ZA

Do not feel shy to mark correct or helpful answer if it helps or is correct

[kani1]

We are in Fuji. I already implemented Dependent field and a simple reference qualifier . Issue is that when category is empty, I dont want to show anything on tier1. Tier1 should be an empty list when category is null. But instead it shows all the records in Tier 1 when category is empty. That is the issue.