I'm new to CDML, so I hope somebody could help me on this one...

I have a database with a text field "Location" . Every record could have multiple locations (Displayed as a standard field in FM, users click enter after each location if more than one is required)

Each record also has a checkbox field "Remove". (Value "checked" when checked)

I need to display a web page that would display every single "location entry used on the DB (there may be a few in each location field) as a header (there would be as many headers as there arer location entries), and records listed after each header that has this criteria (Location contains "location header text" AND "Remove" is not checked)

I don't need a form on this, since no input is required, but I'm stuck trying to display this info.

I have a value list that uses the value from the "Location" field, so I'm thinking about using [FMP-ValueList] [FMP-ValueListItem] and [FMP- InlineAction], but I can't quite put it together.

Can anybody help?

Thanks

Frederick

It is clear that you are confused.

You need to perform your find in the field "location".

On your results page you will need to use an fmp-if conditional such that

[fmp-if: remove .eq. checked]

these records are displayed

[/fmp-if]

or possibly

[fmp-if: remove .neq. checked]

these records are displayed

[/fmp-if]

If you would like to see an example of an fmp-if conditional, you can download either of the two (or both) of the demonstartions which I have posted on the Sample Files forum. You may find several other questions answered there for you as well.

Good luck.

What is happening when you use, [FMP-ValueList][FMP-ValueListItem][/FMP-ValueList]

Are you making a call to FM, with an Action tag, to display this page; e.g. '-view'?

Good Luck.

Garry