This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. <div><br></div><div>-Steve <span></span><br><div><br>On Friday, January 23, 2015, Yasni <<a href="mailto:akayani@aapt.net.au">akayani@aapt.net.au</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
I've created a donation system using CRM and Drupal Commerce.<br>
<br>
I have a view for the most recent 10 donations. All the details I need are<br>
being returned from the CRM table.<br>
<br>
Now after the site has gone live the client recognises that in this list of<br>
10 recent donation is missing the Country.<br>
<br>
That is stored in Drupal commerce as the billing address and not CRM.<br>
<br>
What I need is a few really good references for how to add additional tables<br>
to views. And likely a bit of advice on the complexity of doing this.<br>
<br>
Yani<br>
<br>
<br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote></div></div><br><br>-- <br>Steve Kessler<div>Owner and Lead Consultant </div><div>Denver DataMan, LLC </div><div>303-587-4428</div><br>