Multiple Databases

[dpccgf]

I am a beginner at CDML and have managed to get the Search, Results and Detail pages to work. However, I have one primary database with a relationship to another database. How can I get information from the "related" database to show on a results and/or detail page? I cannot figure this out. Is it possible?

[Garry Claridge]

A couple of ways exist. Firstly, related data can be listed by using Portals; i.e. a portal on the Layout and [FMP-Portal] tags in the page. Secondly, [FMP-InlineAction] tags can be used to display data from multiple files in the one page.

To show a 'details' page a link can be created from a Row in a Portal, or a Record in an InlineAction.

Hope this helps.

Garry

[dpccgf]

All data is from the same layout, so I just used:

<P>Field Name7: [FMP-field: DATABASENAME::FIELD]

This seemed to have worked!

[Anatoli]

For single record yes. For multiple records use [FMP-Portal] as Garry suggested.