Using Send Mail / Data From Portal

[Totes]

Hi,

Here is what I have:

Click Here

What I am attempting to do with the script is send out information in the email body about the offender…name / dob / address etc.

The "Offenders Physical Address" is my problem area on the send mail script, the "Physical Address" comes from a related table (Offender_Address_Info) and is shown via a portal on my main layout.

The problem with the send mail script is that it is pulling the first address that is shown in the portal. I need it to show the last portal row entry. The "Physical Addresses" are shown and sorted by the date they were entered if that helps.

Is there a way for the address in the body of the email to show the last address which is shown in my portals?

Thanks,

James

Edited November 23, 2007 by Guest

[Fenton]

You might want to just Sort the relationship itself by a date descending field, so the latest is on top. Then the relationship will get you the latest. Best to name the relationship with "_desc" or something, so you remember; I do -]

You will want a script and button to create new records for a portal sorted this way however.

[Totes]

Thanks,

I thought that was what I may have to do. Just wanted to see if there was a way to tell the calc to go to the last portal row.

Thanks again,

James