We can only show the values in a custom field based on the value selected in another field. It is possible in a custom field setup.
For example, need a custom transaction line field that has the values of a custom record. This custom record is the child record of the item record.
So whenever we select an item at the transaction line level, the custom field should limit to the values of the main item selected
To apply filters, go to the “Sourcing & Filtering” tab in the custom field setup. At the sublist at the bottom, give filter using value – Parent Item.
Compare Type – Equal to
Compare to Field-Item
So it will compare the parent item name of the value in the custom field to the item selected at that line.
