Combining multiple fields into one

[candreoli]

Hi,

I am trying to take one database which has one ID with multiple records and combine the information of a field in those multiple records into another database into a single record.

example:

Database Contacts has the following fields:

ID

Name

etc...

Database Applications has the following fields

ID

Applications

etc...

Under applications the same ID is a separate record for each application listed. I want to match the application ID to the contact database ID and list all of the applications entries for that name into one field.

How the heck do you do this???

Thank you!! [email protected]

[aaa]

You can do it by script and relation from Contacts to Applications.

But why you dont want to use portal for your goal?

[candreoli]

Thank you. I have used previous versions and this task use to be much more difficult. Portals was easy.

One more question. When I tried exporting to a .csv the information in the portal was garbled. Any suggestions??