Find field value in a portal of multiple records and display it outside the portal window.

[jimkent]

Hi, I have a wholesaler contact database in which I use a portal that points to my document database. Among the document database, I have a field named "expiration Date"  the premise is that one of these documents, and there can be many, in the portal is a license, and that license expires.  The expiration date field which is within the portal is only populated if it is a license document type (using a "document Type" field).

 

How can I take that experation date and show it on the top of my form (outside the portal) so as we browse through the records I can see the experation date of the company's license.

[mr_vodka]

Not entirely sure of your complete structure... Are there many child records with this date filled out?

 

Try looking into the Max ( ) and List ( ) functions as appropriate... If I understand it correctly, List (YourChildRecords::date_expire) should be adequate.

[jimkent]

I'll look into that function, but just to clearify, there are many documents that can attach to the record (many related records) but only one of those related records have a filled in experation Date field.  All the other related records have that field as "null".

 

Thanks.