October 31, 200718 yr Ok I dont use FM that much so please be patient with me. Plus I'm in fm6. I have an inventory db that I'm working on I have main category , sub category 1 and subcategory 2. I have so many main categories and sub categories I put them into thier own files. But I'd like to have the user pick from a pop down for main category and then the sub category 1 and 2 only show sub category data based on what the main category is. example pick main category > cars then Subcategory 1 shows > Ford , Chevy , etc, then Subcategory 2 shows > sedan, truck, van, etc. if there's a resource to read Id be happy to read it or if theres another post whatever. thanks for any help or direction to help
November 3, 200718 yr What you are asking for is called, "Hierarchical Value Lists." Sorry, but I can't remember even how FM6 worked, but I did find this article on JMO's site. Hope it helps.
Create an account or sign in to comment