Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Displaying modifiying account name for multiple related tables


Norma_Snockurs
 Share

Recommended Posts

Hello again,

 

I am stuck on what seems like should be an easy problem to solve.

I have records in a database layout that contain fields from five different related tables. When an entry gets updated in any of the fields from the master table a modification timestamp updates accordingly but in order to get a mod timestamp that reflects modifications to any of the related fields in the same record of that layout I have a calculation that references a mod timestamp in each of the related tables. This works fine:

 

Max(moddate ; rTable2::moddate ; rTable3::moddate ; rTable3::moddate)

 

It simply calculates the most recent timestamp in any related table.

However I am unable to find a way to display or calculate the associated modifying Account Name in the same way. There may be several different users making changes to related fields in a record but how can I make sure that the most recent modifiers name is diplayed along with the timestamp regardless of which related table it was changed in? The 'Max' function obviously won't work in this way.

 

Thanks in advance for any help.

Link to comment
Share on other sites

Never mind, fixed it and it was easy.

cLastmod is the name of the calc field for the 'Max' function above.

 

Case(

cLastmod=moddate ; modname ;

cLastmod=rTable2::moddate ; rTable2::modname ;

cLastmod=rTable3::moddate ; rTable3::modname ;

cLastmod=rTable4::moddate ; rTable4::modname ;

…etc.

)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use