Hi

I want to store portaldata into ONE calcfield. I have 2 db's, filtering on a countryname. DB#1 holds the info of the person inquiering, #2 holds companies that provide the needed info. If in DB#1 a field is populated with 'USA', it'll show up in the portal (in DB#1). The DB#2 companie has one textfield where numerous countries are entered, so theres the relationship and it does work ok - what i need now is to cunstruct a calculated textfield of which the result i can use for emailing. So far this is all blurry... I'll try to explain:

DB#1 : input is 'USA'

DB#2 ; company offers 'USA'

DB#1 : shows names of offering companies in a portal. The portal also holds the comp. emailaddresses and those i need in one line :

If there are 3 offering companies for 'USA' the calculated field should result in: [email protected], [email protected], [email protected].

T.i.a.

Why store the email addresses in a text field when you already have them? Why not use a script and loop through the email addresses in the portal?

The Mad Jammer

One option would be to create a value list (lets call it "CompanyEmails") based on the same relationship that is displaying data in your portal. The value list will display the email addresses. then create a calculation as follows:

ValueListItems ( Get ( FileName ) ; "CompanyEmails" )

The calculation must be unstored, so that it will update when the relationship changes (ie: when portal data changes). The result will be a list of all e-mails (any duplicates will be removed)

Peter