I'm trying to figure out how to relate data in one form to another.

[marketingmike]

so here is what I am looking to do. I have customers on maintenance who i support. I am trying to make it easier to see if they are current on maintenance. so far i have a maintenance expiration box. but would like to make that display yes or no in another form/field based on if that date is past todays date. is it possible to do something like that?

thanks for any and all help
Mike

[snikwahj]

Mike,

You should be able to achieve this with the "process_record" logic hook of the bean you want to display the Yes / No field in. The "process_record" hook is where you can inspect (and alter) field values retrieved in the bean before they are displayed or used.

For more complex display processing you can override the detail view of the bean by creating a custom view.detail.php file and overriding the display() function in there.

Both these techniques are described in detail in the appropriate developer guide for the version of SugarCRM you are using.

Thanks,

JH.