Kris
Fri May 25 07:36:19 CDT 2007
You could create a customised entity that does basically the same
thing as the CustomerAddress entity, but more suited towards your
needs. While not the best way of doing things, this would make what
you want possible. Just create a many to 1 from the new custom
address entity to whatever entities you wish to use it in - that will
give you the linking you desire, and by creating many to one from the
custom address entity to whatever you wish to use it in, you can add
many addresses to a single account, or contact or...
This is basically how CRM uses its CustomerAddress entity, only in a
much nicer way - it has a single link that points SOMEWHERE... but
isn't locked into anywhere in particular.
Kris Rhodes
----
MS CRM Certified (Installation & Configuration, Customisation)
CRM 3.0/VB.NET 1.1 Developer
Quantum Business Technology
Perth West Australia
Blog:
http://rhodeskc.wordpress.com
This information is intended to be advice and advice only.
On May 25, 4:56 pm, Pedro. R. <Ped...@discussions.microsoft.com>
wrote:
> Hi,
>
> I changed that fields on table CustomerAddressBase but I cant still change
> the length of the field on CRM side. Gives the error message that I must
> choose a length from 1 until 50.
>
> Is it recommend to create a new customized field for addresses instead?
> What are the impacts on reports and other forms? Anything special?
>
> Thanks,
>
> "uMar Khan" wrote:
> > Hi Pedro,
> > Direct database alterations are strongly not recommended and it is
> > considered unsupported from Microsoft.
>
> > Account and contact uses CustomerAddressBase table for their addresses of
> > line1, 2 and 3.
>
> > --
> > PLEASE do click on Yes or No button if this post was helpful or not for our
> > feedback.
>
> > uMar Khan
> > Email for direct contact: imumar at gmail dot com
>
> > "Pedro. R." wrote:
>
> > > Hi,
>
> > > Well my question is how do change the length of the fields "Address_line1",
> > > "Address_line2" and "Address_line3" of the forms Accounts, Contacts and Leads.
>
> > > I looked for this fields directly in the SQL Server tables but the only
> > > address fields I found was the fields "Line1", "Line2" and "Line3" of the
> > > table InternalAddressBase wich I think are not the fields I need to
> > > change.... Anyway I changed the length of this fields on the SQL Server from
> > > 50 to 100 but when I tried to change this lengths directly on the CRM -
> > > Customizations it stills gives the error message: "You must to use a length
> > > between 1 and 50".
>
> > > Do you know wich tables have the address fields of the Contacts, Accounts
> > > and Leads? And how do I can change the lengths of this fields? (without the
> > > error message) :)
>
> > > Thanks!