I need to create a report for our CRM users. They want to have certain
fields about a contact such as name numbers e.t.c... also they want the
"notes" from CRM to be displayed next to each contact in the report.

I am fine with the first bit however I can't seem to find which table the
"notes" are in - Any ideas?

Also does anyone know where I can get a diagram of all the CRM 3.0 tables
please?

Cheers guys

RE: help with a report by MichaelLangdon

MichaelLangdon
Mon Jun 11 08:33:01 CDT 2007

The table structure and relations diagram is available at:

http://www.microsoft.com/downloads/details.aspx?familyid=DA8D5048-615E-43C0-AB31-8FB5DA70216B&displaylang=en


--
Rgds

Michael
MCDBA 2000 | MCITP DBA 2005


"Mark.Dobson-Hill" wrote:

> I need to create a report for our CRM users. They want to have certain
> fields about a contact such as name numbers e.t.c... also they want the
> "notes" from CRM to be displayed next to each contact in the report.
>
> I am fine with the first bit however I can't seem to find which table the
> "notes" are in - Any ideas?
>
> Also does anyone know where I can get a diagram of all the CRM 3.0 tables
> please?
>
> Cheers guys

RE: help with a report by MarkDobsonHill

MarkDobsonHill
Mon Jun 11 09:06:02 CDT 2007

Thanks for that - will be a great help.

Does anyone know where I would find the notes table though?

"Michael Langdon" wrote:

> The table structure and relations diagram is available at:
>
> http://www.microsoft.com/downloads/details.aspx?familyid=DA8D5048-615E-43C0-AB31-8FB5DA70216B&displaylang=en
>
>
> --
> Rgds
>
> Michael
> MCDBA 2000 | MCITP DBA 2005
>
>
> "Mark.Dobson-Hill" wrote:
>
> > I need to create a report for our CRM users. They want to have certain
> > fields about a contact such as name numbers e.t.c... also they want the
> > "notes" from CRM to be displayed next to each contact in the report.
> >
> > I am fine with the first bit however I can't seem to find which table the
> > "notes" are in - Any ideas?
> >
> > Also does anyone know where I can get a diagram of all the CRM 3.0 tables
> > please?
> >
> > Cheers guys

Re: help with a report by vidya

vidya
Mon Jun 11 09:59:12 CDT 2007

The notes view would be called FilteredAnnotation ( and the objectid
field links it with the object for which the note is created)


Vidya

On Jun 11, 10:06 am, Mark.Dobson-Hill
<MarkDobsonH...@discussions.microsoft.com> wrote:
> Thanks for that - will be a great help.
>
> Does anyone know where I would find the notes table though?
>
>
>
> "Michael Langdon" wrote:
> > The table structure and relations diagram is available at:
>
> >http://www.microsoft.com/downloads/details.aspx?familyid=DA8D5048-615...
>
> > --
> > Rgds
>
> > Michael
> > MCDBA 2000 | MCITP DBA 2005
>
> > "Mark.Dobson-Hill" wrote:

> > > I need to create a report for our CRM users. They want to have certain
> > > fields about a contact such as name numbers e.t.c... also they want the
> > > "notes" from CRM to be displayed next to each contact in the report.
>
> > > I am fine with the first bit however I can't seem to find which table the
> > > "notes" are in - Any ideas?
>
> > > Also does anyone know where I can get a diagram of all the CRM 3.0 tables
> > > please?
>
> > > Cheers guys- Hide quoted text -
>
> - Show quoted text -