Yes, I've already defined "Limits Values By". It will help restrict the options for the second filter. But it won;t automatically select the option for me. You can see the second filter is still "All", while the option is already only "G0221". Is there any system setting for this part?

Sure, let me explain using below figure. Multiple ITEM_NUMBER may belong to the same GROUP_ID. But GROUP_ID may be just a serial number, and users will not use it for filtering. So what I want is for users to be able to search for a specific ITEM_NUMBER they are looking for, while the same time, it will also filter out the…