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, 200718 yr by Guest

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.

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