Conditional Value List with CDML

Hi,

Maybe I'm an idiot, but I can't seem to figure out how to make Garry Claridge's suggestions for a dynamic value list work. I am a CDML moron, so that may explain it. This is my first try using CDML although I have been developing in Filemaker for years. I have a set of 3 fields for searching a catalog. Main field is Category, which works fine. The second field is ProductType, which uses a value list where the values are pulled from another file through a relationship. The third field is Vendor, which uses a value list that is pulled through a concatenated self-join relationship of Category_ProductType. I tried to take Garry's suggestion for the person with the travel database and change the names of the DB, Layouts, and Fields to work with my stuff to no avail. The fields mentioned above have twin Global text fields in the database that display records in a self-join portal. It would be great if I could duplicate the portal on the web as long as it doesn't take forever to load as it does with IWP when there are more than 10 matches. A regular search using the plain text fields with dynamic value lists would be just fine as well.

Main DB Name: Products.fp5

Fields to search on: Category, ProductType, Vendor

Value List Names: Cat(field values of Category)

Cat2(field values of Description from related file Cat2.fp5)

Vendor(field values from concate nated self-join of Category and ProductType)

The Cat2 Value List populates the ProductType Field. Any help would be greatly appreciated as I have been banging my head against a wall for hours already. Remember, I am not real familiar with CDML so please be specific! Thanks in advance.

Edited November 21, 200718 yr by Guest