Hi!
i want to know in which table picklist values are stored
thanks

Try looking in the Stringmap table, if your wanting to access the values via
code look into CRMCustomization in the SDK it is something like this:

Dim customization As Microsoft.CRM.Proxy.CRMCustomization = New
Microsoft.CRM.Proxy.CRMCustomization
Dim strResultsXml As String = customization.RetrievePicklist(userAuth,
Microsoft.CRM.Flags.ObjectType.otContact, "preferredcontactmethodcode")

"pepe" <pepe@discussions.microsoft.com> wrote in message
news436311A-AC86-4E7C-9D5E-91578E905C59@microsoft.com...

and if i am looking directly to the database?
thanks

"Rick" wrote:

as Rick mentioned in his post...in the mscrm database, look in the stringmap
table

Dave

"pepe" <pepe@discussions.microsoft.com> wrote in message
news:359D545B-B00C-488F-B165-A19047E33FFC@microsoft.com...

Thanks to both

sorry, I didnt understand what Rick wrote

"Dave Ireland" wrote:

FYI, don't think that modifying this table will affect the picklist though.
This is only there for reporting purpses.

--

Matt Parks
MVP - Microsoft CRM


"pepe" <pepe@discussions.microsoft.com> wrote in message
news:A6B801A8-9091-406A-8824-264CFF750421@microsoft.com...
Thanks to both

sorry, I didnt understand what Rick wrote

"Dave Ireland" wrote:

Hi

I want to know if someone have the list of tables and what it is stired on
each one.

thanks

"Matt Parks" wrote:

The picklist values are stored in the fieldxml column of the
organizationuibase table. Thiis is an xml document that contains the
definition of all fields on the form for an entity.

Knowing this is not much use, as this information just the source for the
xsl files for each entity (stored in the _xslfiles directory), and the
stringmap table, as described below. The xsl files and the stringmap table
are updated when customizations are published using Deployment Manager




"pepe" wrote:

Pepe,

I can only assume, that like me, you were looking for a way of copying the
values you had in one picklist as the values for another picklist. A good
example of this would be: I want to know what stores my customers like to
shop in. I would like their primary choice, secondary choice, and then a
third choice. All of the store choices are the same (ie: wal-mart, target,
dillards, gap) and so each picklist should display the same values. Rather
than retype this picklist, I wanted to come up with a way that I could re-use
the same picklist.

This procedure turned out to be much easier than I expected. If you would
like detailed instructions on how to do this, please feel free to email me at
jnetmcp@gmail.com.
--
jNet
"Nothing but the best"


"pepe" wrote: