I am working on a sharepoint online classic team site. where i added a custom list named "Pricing", which contain these main 2 fields:-
1) a column named "Type" of type drop-down list and have 2 options (General or Detailed).
2) a column named "Parent" of type lookup, which reference the same list (self-lookup field).
now the "Parent" lookup field will show all the items from the current list (Pricing), but i want the lookup field to only show the items which have "Type" = "General". so is it possible to apply filtering to the lookup columns? Thanks