It is possible to filter link field based on child table field on other doctype.?
doctype 1: purchase order
doctype 2: item
In items table in purchase order , im trying to filter the default item_code based on company.
In Item doctype, i have created a child table that consist of company and warehouse name.
I would like to compare between these two doctype, purchase order and items, if the company in purchase order doctype is in existed in company field in child table at items doctype, it will list the items.
my script but didnt work:
Default Warehouses : child table name in items doctype.
Any input is really appreciated. Thanks