getting data from related records in one textfield

[waldi]

hallo! probably someone has experiences with that. i

[jeffer]

Hi,

Could you be some more specific? When and how is your related record created? The best way is to have one text field to create the many to one relationship. It's a little odd to have one textfield for each related record since the count of those records is always changing.

greetz,

Jeffer

[waldi]

yes, that

[jeffer]

Well...when it are all tyhe emails of one specific day, use the date as the relationship:)

greetz,

Jeff

[waldi]

well, my problem is not the relationship itself.

my problem is getting the content of one text field in different related records into one single text field just seperated by a paragraph.

[Lee Smith]

You can do this in couple of ways using the concatenating text methods. Look up concatenating text in your online help.

This can be a new calculation field, or used in a script step with such as Set Field, or Insert Calculated Result.

HTH

Lee

[csbalogh]

Have you tried Troi Text Plug-in's Sum Text function? It should do the job for you.

http://www.troi.com/software/textplugin.html

(with description of the sumtext function).

csb

NL

[LaRetta]

Hi Waldi,

Could be based upon day (date) as Jeffer suggested but I'd use global date so you can freely copy (archive?) several email dates, or miss a few if necessary. If you base your relationship on a calc you may be limiting your flexibility but if using a global (date), you can choose when to copy them.

Relationship: Main:gEmailDate (global date) to Related::EmailDate (standard date).

Create a new record in main, enter date to copy in gEmailDate and you have a relationship. Then Go To Related Records [ Show ] to bring up set of related (same date) emails.

Be careful about field size that you don't hit FM's limits!!

/b]New Record/Request

Set Field [EmailDateField, gEmailDate] (test to make sure it's not empty first)

Exit Record/Request

Go To Related Record [ Show ]

Set Field [ Main:YourTextField, Related::YourTextField ]

Freeze Window

Loop

Go to Record/Request/Page

[ Next, Exit after last ]

Set Field [ Main:YourTextField, Main:YourTextField & "