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.

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.

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.