Fields, portals and iPods

[WingNutt]

Can I combine the data from portal rows to fill one ordinary field?

I have two tables linked by a one-to-many relationship. Records in the one table show related records from the other in a portal. Ideally I want to export the records from the one table with a new field combining the data from the relevant portal rows. (Once reduced into this flat file kind of format, the data can then be exported for use on my iPod.)

Thanks

Wingnutt

[mr_vodka]

One suggestion would be to use a script that would perform a GTRR (Go to Related Record) step and then loop through all the records while doing a concat then copy this value to the main record.

In other words:

Go to Related Record [show only related records

Set Variable [$concat; Table2::fieldName]

Loop

Go to Record [Next; Exit After Last]

Set Variable [$concat; $concat & ¶ & Table2::fieldName]

End Loop

Go to Layout [Original Layout]

Set Field [TableA::NewField; $concat]

[WingNutt]

Thanks very much, John

I haven't yet had time to try your code, but I will do so soon and let you know how I get on.

Wingnutt

[WingNutt]

With your help I've now played around with the code and got it to do just what I wanted.

Thanks very much.

Wingnutt