Hi,

Does anyone have answer to this problem?

I have a invoice page at the end of the order process.

In this page I have a portal to look up the ordered items (orderitems -db)

I would like to display the price (which is the same for all items) which is on the host -db (orders) . I have use a normal cdml tag to get the price i.e.

[FMP-portal]

[FMP-field:voi::item] price = [FMP-field:price] - *this bit*

[/FMP-portal]

it works on the first record, but the ones after it just leaves blank.

any ideas?

Lewis.

HI, you need to define the relationship name in the portal opening tag-

[FMP-PORTAL: relationship]

[FMP-Field:relationship::fieldname]

[/FMP-PORTAL]

To get it to display nicely, you can embed a table within the portal, like for a search return.

regards, jeff

Lewis,

Do you have the [FMP-Field: price] in the portal back on the layout? Does it work OK there? If so you may need to create a calculated field, in the orderitems file, which displays the price from orders; then place it in the portal on the layout.

All the best.

Garry