Calculation to get collection of field contents to a single field

[HAF]

Hi all,

 

I have a table A with a parent tables B, C

 

- I have a portal created for B&C on A's layout

- I want to get some recent activities to be shown in find mode on a portal (ie sorted on recent dates on top)

 

- Issue is > how do i get a collection of few fields in to one field and get this represented on the portal?

-- such as a formula in one field which is a collection of some text fields and date - ( this will look like a paragraph of text starting with a date)

 

Could some one help?

Haf

[comment]

I have a table A with a parent tables B, C

 

- I have a portal created for B&C on A's layout

 

I am afraid your description makes no sense. If B and C are parent tables of A, then there will be only one related record in each - and a portal is unnecessary.

 

 

I want to get some recent activities to be shown in find mode on a portal

 

I am afraid that makes no sense either. No data is shown in Find mode (except data in global fields).

 

 

I suggest you rephrase your question using meaningful names for your tables and fields (abstract names like A, B and C are really difficult to follow), and provide an example of the data you have and of the result you are hoping to get out of it.