Hi,
Is it possible to create a Custom Field (Persistent or otherwise) that is selected via a LoV, and set it up so that only the parts with those Product Codes are visible when a new line is created?
Here is the list:

When creating a new line in Engineering Part Revision under ‘Consists Of’, it would be great if you could select your Product Code and only see options when choosing a Part Number that has those Product Codes.
I’ve created a persistent field called ‘Test’. It is possible to bring up the LoV and select your Product Code:

Here, I would like it so that when selecting the ‘Part Number’, only the items within that group appear. Right now, all part numbers are shown:

I know it can be done with an advanced search:
part_no in
(
select ip.part_no
from &AO.inventory_part ip
where ip.PART_PRODUCT_CODE = '&ProductCode'
)
But is it possible to achieve the same without using advanved search?
I hope someone can help.
Best regards,
Christian