Hi...

I need help with the following....

My database consists of Carbrands and Types. In FMpro I have made an pop-up list for the Type field which only shows the corresponding Types based on the chosen Brand in the first field. (determined by relationship) I don't know how to make this happen in CDML. I suppose I have to submit a value to fill in the Brand field.

so if anyone can help me with providing me with this "TAG" or an link to a site with such an example. I'd really appreciate it.

Thanks

Tianshi

Here is a link to a thread that shows an example, as well as a good discussion of using the equal sign with a pull down value list:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB22&Number=79934&Forum=UBB22&Words=value%20list&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=1year&Main=78857&Search=true#Post79934

Pop-up's (Vlauelists) using related values do not work through CDML.

Some workarounds exist. Check the archives, I will also check them later today.

All the best.

Garry

Tian,

You have a couple of options to solve the first problem, i.e. Related ValueLists.

One to consider, is the use of [FMP-InlineAction] functions to populate the ValueList directly from the related file.

The second problem is to populate Pop-ups with related values when the Main ValueList (Pop-up) is changed.

For a Dynamic ValueList you need to decide between, acessing the database each time the Main ValueList is changed, or loading the values into Javascript Arrays, then using Javascript to change the dependent ValueList (Pop-up) each time a change is made.

Hope this helps.

Garry