Finishing up my project, I have located a Filemaker table that contains all the NAICS codes available that I have brought into my DB file. It's a huge list with more than 20, 000 records. What I'd like to be able to do is have the user pick from a drop down list that is organized by first by Industry Title, and then show the industries that are available under that title.
Industry titles are prefaced with a certain number. For example, Agriculture, Forestry, Fishing and Hunting all fall under the codes that begin with 11. You can see an example of how this is organized from the NAICS website here: http://www.naics.com/search/
So my question is, what would be the best approach to handle this? I'd like for my value list to first show the 20 industries and then based on that selection, be taken to a list that only shows the titles for that industry. I know I can use conditional value lists....but can you make both selections from the same field or do you have to have two fields, one for the industry and then the second that populates with the titles for that industry?