Refer to a Locations Table in the Lead form

TheMSsForum.com: The Microsoft Software Forum

Hi,

I need to use/refer a ISO location table.

I'm customizing the leads form and need to include an origin and destination
location fields, and would like to choose the values from the locations table.

How can I do that ? Can I create this table in MSCRM or refer to other SQL
DB ?

Thank you,
Hugo
Top

Re: Refer to a Locations Table in the Lead form by Guy

Guy
Mon Nov 08 02:41:04 CST 2004

You will have to create your own Lead ASPx form and manipulate the data
yourself (via methods described in the SDK).
You cannot add direct "Lookup" fields (referencing another database table)
in the current version of CRM.
It is probable that this type of functionality will be available in V2.
Guy.

"Hugo Fonseca" <HugoFonseca@discussions.microsoft.com> wrote in message
news:4009178D-EACE-4CD2-93D0-CB4BBF6C3DEE@microsoft.com...
> Hi,
>
> I need to use/refer a ISO location table.
>
> I'm customizing the leads form and need to include an origin and
> destination
> location fields, and would like to choose the values from the locations
> table.
>
> How can I do that ? Can I create this table in MSCRM or refer to other SQL
> DB ?
>
> Thank you,
> Hugo
>
>


Top

Re: Refer to a Locations Table in the Lead form by HugoFonseca

HugoFonseca
Mon Nov 08 05:22:02 CST 2004

Hi,

Yes I've read lots of threads with that information.

Yesterday i've spent lot of time trying to get useful documentation,
articles and white papers on how to do it, but didn't find anything useful.
Poor examples, with diferent things...

Do you have any links where I can find how to make an sql query against
another SQL DB and put the result an picklist for example ?

Thanks,
Hugo

"Guy Riddle (Snapdragon)" wrote:

> You will have to create your own Lead ASPx form and manipulate the data
> yourself (via methods described in the SDK).
> You cannot add direct "Lookup" fields (referencing another database table)
> in the current version of CRM.
> It is probable that this type of functionality will be available in V2.
> Guy.
>
> "Hugo Fonseca" <HugoFonseca@discussions.microsoft.com> wrote in message
> news:4009178D-EACE-4CD2-93D0-CB4BBF6C3DEE@microsoft.com...
> > Hi,
> >
> > I need to use/refer a ISO location table.
> >
> > I'm customizing the leads form and need to include an origin and
> > destination
> > location fields, and would like to choose the values from the locations
> > table.
> >
> > How can I do that ? Can I create this table in MSCRM or refer to other SQL
> > DB ?
> >
> > Thank you,
> > Hugo
> >
> >
>
>
>
Top