Value list from portal won't appear?

[retropia]

I've searched through the forum archives, and haven't been able to locate any information on this subject. I've got two databases, and the portal from the main to the secondary database works on the web page as intended. The data is correct, and editing the data is no problem. In FileMaker itself, the value list works in the portal. But I can't get that value list from the secondary database to show in my web page.

A value list from the main database works, so I'm wondering if there is some different CDML coding I need to use (I'm using FMP 5.5), or if it isn't possible to get that portal value list to appear.

I guess if that's the case, I can always create a static value list for the website interface, but it makes for more maintenance whenever the value list changes.

Thanks!

[Garry Claridge]

Unfortunately, related valuelists do not work through WebCompanion

Depending on the size of the file, you may be able to use Javascript to produce a valuelist from the key field of the related file. Or, you could use an [FMP-InlineAction] tag to grab the ValueList from the related file.

All the best.

Garry

[Anatoli]

IMHO you can use Inline to display the portal records without portal and then it should work! Am I right?

[retropia]

Thanks, Garry & Anatoli! I had a devil of a time figuring it out, as I'd never before used FMP-InlineAction, and the CDML Reference Guide was spotty about this tag. Every combo I tried failed. I kept digging for samples and examples, and I found one here, from the CDML forum, of Garry's from 01/2002. Here's how I modified his code to work:

<select name="MAKE">

[FMP-InlineAction: -db=FinCars2.fp5, -lay=Layout #1, -view]

<option value=""> - No Selection -

[FMP-Option: MAKE]

[/FMP-InlineAction]

</select>

At first, on line four, I had [FMP-Option: MAKE, List=Car Makes] and that wasn't working. "Car Makes" is the name of the only value list for the field "MAKE". I remembered reading somewhere that if there was only one value list for a particular field, you didn't have to list it. So I tried deleting it, and it worked!

Is the reason it didn't work because there is a space between "Car" and "Makes"? I seem to recall that spaces sometimes creates problems in Web Companion.

This particular value list is used for posting a new record, and now I've got to make it work for editing existing records.

Is there a book or reference guide for CDML? The FileMaker reference guide is very limited, and the FM website has been of no help.

Once more, this site saved my bacon . . . thanks again!

[Anatoli]

The main thing -- it works

I was thinking on different solution: Display records from one file and then instead or [portal] [/portal] do [inline] records directly from portal file [/inline]

In any case -- never use space. It can work and in some cases it would not.

Use only alphanumeric and '_' underscore.

It will save you hours during your active programming life.

[retropia]

My latest stumbling block: editing the existing record data isn