Create text from combined portalrows

[peter100]

I'm trying to make a textfield combine the rows in a portal but don't get it to work properly. I'm working with FM6. A full description is below. Hope someone can help.

I've made two simple databases to test the procedure. If it works I will implement something like it in a larger database. The databases are called 'Countries' and 'Hotels'.

The database 'Countries' consists of 2 fields:

- Country

- Text

The database 'Hotels' consists of 3 fields:

- Hotel

- Country

- Url

I've made a relationship based on the field Country in both databases. A portal in 'Countries' is showing the urls of the corresponding hotels from 'Hotels'.

So far so good! Problem is getting the records in the portal to combine in the field 'text'. I've tried several options last night but I can't get any of them to work properly.

Hope someone can point me in the right direction.

Peter

[-Queue-]

Try this on for size.

HotelCountries.zip

[peter100]

Thanks! It seems to do just what I'm looking for.