How to source the selectable list of a field from another field. The two lists are different but within one of the custom records, there is a list of the same record

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to create a dependent dropdown list where the selection of one field influences the options available in another field. This can be achieved in NetSuite using the Sourcing and Filtering feature on custom fields. Here are the steps to set this up: 1. Create a custom record for each list you want to source from. For example, if you have a list of states and a list of cities within each state, you would create a custom record for states and a custom record for cities. Each city record would have a field that links it to a state. 2. Create a custom field on your transaction form for the first list (e.g., states). This field should be a List/Record field that sources from the custom record you created. 3. Create a second custom field on your transaction form for the dependent list (e.g., cities). This field should also be a List/Record field that sources from the custom record you created. However, in the Sourcing & Filtering section of the field setup, you should set the Source List to the first field (states) and the Source From to the field on the city record that links it to a state. This setup will ensure that when a state is selected in the first field, only cities linked to that state will be available in the second field. Here are some helpful links from the NetSuite Help Center that explain this process in more detail: - [Dependent Dropdown Lists](https://tstdrv1776198.app.netsuite.com/app/help/helpcenter.nl?fid=section_N2840468.html) - [Sourcing](https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N2839623.html) - [Filtering](https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N2840153.html) ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******