CRM 2011: How to fetch records related to given entity in “many to many” relationship RRS feed

  • Question

  • My goal is to get invoices related to given contact, if I acquire data from the table named "contactinvoices" (intersect table), then I see that this table is empty. I have solved that Problem by requesting records directly from invoice table with "contactid" (contacts) = "costumerid" (invoices). As I see now that this approach is good for contact and account tables and for invoices and quotes. For which entities else can i use such way? And what to do with another entities? Intersect tables?
    Friday, June 21, 2013 11:43 AM


All replies