Related records in email script

[Sutonimh]

Hello,

I'm having an issue with some related records and an email script I built in my DB.

I have a basic table that has all Job information. It is related to a table that has equipment information specific to each job. The two tables's are related via a serialized field "Job ID"

The problem is this. I want a form email that is populated from the Job database that also includes a list of all equipment from the related table. I can get it to populate the email with information from the first related record easily, but after that I am lost.

I've done quite a bit of reading on various forums on similar topics, but most approaches to similar issues seem way too complicated. Does anyone have an idea on a simple way to achieve this?

Edited October 7, 2010 by Guest

[bcooney]

Use the List ( ) function to "bring up" the child record info into the parent. Then, include that List calc result in your email body.

[Sutonimh]

Thanks a bunch. I knew it was a simple thing. This works perfectly.

[bcooney]

Glad to help. Remember, you can concatenate some fields in the child and then use List ( ) to gather the concatenated field (good for Order Line Items).