concatenate several field together, other than in a portal

[Capt JB]

Hello,

I gonna need help for the following. I turned it around several times, but cannot get a result.

I have two files, one helicopter database, and one registration database linked by a helicopter ID.

I would like to regroup all registrations having the same helicopter ID in one single field in the database registration or in the database helicopter (the simplest will be great).

The field storing registration is a text field, the helicopter ID is a calculation (concatenate of three other text fields).

Writing this I realize it could be used in many other applications.

Any help will be very much appreciated, for both the teaching and the solution.

[comment]

I would like to regroup all registrations having the same helicopter ID in one single field

If you are really using version 7, then this is going to be a bit complicated - though still possible. But why do you need this, when you can show them in a portal?

the helicopter ID is a calculation (concatenate of three other text fields).

Not related to your question, but it's probably not the best choice. Same for keeping two files instead of two tables in a single file.