Advanced Portal Functionality

[michaelnyc]

Three tables:

PERSON - one individual

LETTER - one letter

SENTLETTER - one letter sent to one individual

If I am looking at a PERSON record, and I have a portal of all of the letters that should be sent to that person, can I have in that same portal the related "Date Sent" field from SENTLETTER so that it only comes up on those letters that have a related SENTLETTER record for that one PERSON record? I can't seem to make this relationship without making a global in LETTER and populating it through a script with the current PERSON Unique Serial.

This should be able to be done, but I'm not sure how. Any help on this would be greatly appreciated.

Thanks all,

Michael

[Fenton]

The portal should be from Person to SentLetter. You could use what I call an "If" ID, in SentLetter:

_cPersonID_if_Sent =

Case ( not IsEmpty (DateSent); PersonID )

Then target that from Person, and use it for a portal of letters sent (to that person). The above only makes sense if you have records in SentLetter which do not yet have a DateSent, ie., letter drafts. Otherwise I have no idea what exactly you've got in there.

I also have no real idea what "Letter - one letter" means; a letter template?