# Cross reference CRM and Sales database information in a dashboard widget

**URL:** <https://pug.phocassoftware.com/t/cross-reference-crm-and-sales-database-information-in-a-dashboard-widget/1930>\
**Category:** Ask the Community\
**Tags:** crm, howto\
**Created:** [July 29, 2021, 7:53am UTC](https://pug.phocassoftware.com/t/cross-reference-crm-and-sales-database-information-in-a-dashboard-widget/1930 "2021-07-29T07:53:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LauraJ14](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@LauraJ14](https://pug.phocassoftware.com/u/LauraJ14)\
**Post date:** [July 29, 2021, 7:53am UTC](https://pug.phocassoftware.com/t/cross-reference-crm-and-sales-database-information-in-a-dashboard-widget/1930/1 "2021-07-29T07:53:49Z")

</div>

Hi there,

I want to create a dashboard widget that shows the number of accounts that are either 0 spend or behind budget that haven’t had a CRM action recorded against them in the last month.

From looking at dashboard widgets it seems that I can only cross reference information form within the same database, not across two databases, unless I am missing something?

If anyone has any ideas they would be welcome!

Kind regards

Laura

---

<div class="post-metadata">

**Author:** ![tim.janes](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/tim.janes/32/361_2.png) [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\
**Post date:** [August 13, 2021, 8:47pm UTC](https://pug.phocassoftware.com/t/cross-reference-crm-and-sales-database-information-in-a-dashboard-widget/1930/2 "2021-08-13T20:47:57Z")

</div>

Hey Laura,

If you have access to Database Designer and your customers’ account#'s on CRM line up with their account#'s in your Sales database, you could probably map the CRM activity info into the Sales database as a Measure (e.g. “Activity Count”), then use that within a dashboard widget running off the Sales database.

Tim