How to copy portal data in field?

[Kip]

Hi portal wizards,

I have two databases connected to eachother: "related projects" and "all projects" with a relationship called "projectid", matching the field "projectid" from "related projects" with the field "projectid" from "all projects".

In the database "related projects" I have created a portal that (in case of a match) displays the related records in the following related fields:

code artist title

BONJA-001 james bond the secret filemaker tricks

BONJA-002 james bond the secret revealed

I am searching for hours now for a way to copy all data (or per row) displayed in the portal into another field making it possible to do other things with it)

In the field the data should be separated by a tab which would result in:

BONJA-001 james bond the secret filemaker tricks

BONJA-002 james bond the secret revealed

Can someone help me please. I think I am overlooking something, but I can

[-Queue-]

Hi Thomas, good to see you again.

It would probably be easiest in the main file to

Set Field [text, ""]

Go To Related Records [show only related, allproj]

Perform Script [sub-scripts, External]

Refresh Window

In the related file, the external script would be

Go to Record/Request/Page [First]

Loop

Set Field [relproj::text, relproj::text & Code & " " & artist & " " & title & "

[Kip]

Hi man!

Good to see you again too! Your solution works like a charm. Thanks very much.