Valuelist, related values

[Spacemanspiff]

Hi!

I'm trying to show a valuelist on a webpage (search form) using CDML...

When I set up the valuelist in the FileMaker-file to contain "values from field", it's not a problem - the valuelist is presented on the webpage.

But when i change the definition of the valulist in the FileMaker-file to only contain related values... It doesn't work! No trace of the valuelist on the webpage!

The relation to control the valuelist is from a Global field in the same file set to "sound" and related to all items labeled "sound".

The "related valuelist" is working great in the FileMaker-file by the way.

Please help!

[Garry Claridge]

I just tried the same thing as an experiment. The result is that I have the same problem. I am using FMP5.5v2 on OS X.

Back to the drawing-board!

All the best.

Garry

[Spacemanspiff]

FileMaker Pro 5.5 , WC 5.5v3 Mac OS 9.2 US

But I've solved it with a calculation field that generates the code f

[Vaughan]

It's well known that related value lists don't work through web companion. There are several work-arounds. However I'm not sure what your solution does. Could you explain it?

[Jeff Spall]

Hi, I'm in the process of building an online image resource database where, in Filemaker, there is a whole cascade of related value lists in one file;

Section

Category

Subcategory1

Subcategory2

then the record information and free text fields.

........each one is dependant on the one above.

The way I have the web interface structured is to separate the value lists into three files with a relationship within each, so the home page shows all of the sections with the categories as a portal to each, click a category to see all the subcategories, click one of those to see the sub-subcategories. When the search of the lists reaches any point where there are no more levels, the value is passed to the image resource database and the results are returned.

This is kinda hard to explain in words, but email me for a url to the site where it's being built.

regards, jeff

[Spacemanspiff]

quote:

---

Originally posted by Spacemanspiff:

But I've solved it with a calculation field that generates the code f

[Vaughan]

This can be done with repeated find processes. The user selects a value from menu 1 and submits. There is a TechInfo article about the pprocess: 105336 "Conditional value Lists for the Web." Just be open minded about it: the process does not actually use value lists in FMP, it generates an HTML menu. It's the most robust and protable solution possible.