how to filter values of custom field based on another custom field

AI generated answer (using internal Slack threads):

To filter values of a custom field based on another custom field in NetSuite, you can use the sourcing and filtering options available in the custom field settings. Here's a step-by-step guide: 1. Navigate to the custom field you want to control the choices on. 2. Go to the 'Sourcing and Filtering' subtab. 3. In the 'Filter Using' section, select the field you want to base your filter on. 4. In the 'Filter Compare Type' section, select the type of comparison you want to use (e.g., 'equal to', 'not equal to', etc.). 5. In the 'Filter Value' section, select the value you want to compare with. Please note that this method works when the custom field you want to filter is a list/record type and the field you want to base your filter on is also a list/record type. If the fields you want to filter are native fields, you might need to use a workflow to achieve your needs. If you're trying to filter a custom field that contains contact records for both parent and child records, you might need to check your sourcing in your custom field. It's possible that the sourcing may be incorrect, which is why you're not able to filter both parent and child records. For more detailed information, you can refer to this NetSuite SuiteAnswers article: https://netsuite.custhelp.com/app/answers/detail/a_id/85126/kw/custom%20field%20filter ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******