Good afternoon List, I've been told by folks on this list, that the solution to this situation resides within nested lists. Please consider making any suggestions to help me move forward on this phase of my project. I've created a screen which has 3 fields, The first field displays a list of available geographies, at different levels of hierarchy depending upon the user's selection from a drop-down menu. The choices in this drop-down are, ZONE, REGION, MARKET, and ACCOUNT. The second field displays all of the selected geographies. The user selects geographies by hiliting them in field 1 and clicking the SELECT button to add to field 2. The nested lists come in to play in this next explanation. There are 1575 ACCOUNTS that roll-up to 118 MARKETS, which roll-up to 24 REGIONS, which roll-up to 15 ZONES. So in theory, this is what has to happen is this: If the user selects the EAST ZONE, and then clicks on the drop-down menu and selects REGION, the field should then show all the Regions within the EAST ZONE (which include, New York, New England, Mid-Atlantic, and Great Lakes) If the user then selects MARKET from the drop-down menu, the field should display all the Markets within the 4 Regions (there are 10 Markets) Selecting ACCOUNT from the drop-down does the same (display all Accounts within the Regions) Additionally, if the user only selects the New York Region, then selects MARKET from the drop-down, the field should ONLY show the Markets within the New York Region. Same is true for selecting ACCOUNT, the field should only show those Accounts within the New York Market. I hope this made sense. Currently, what I have are field members, with all the Zones in 1 field member, all the Regions in another field, and so on. I also know, which Accounts belong to which Markets, which Markets belong to which Regions, and which Regions belong to which Zones. Can anyone suggest how I can get started with this task at hand? As always, with the utmost respect for your knowledge and willingness to share it, g fritzinger [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]) Lingo-L is for learning and helping with programming Lingo. Thanks!]
