I'm a noob with SalesLogix I apologize in advance if I get some of the SLX specific lingo wrong.

We use Web exclusively except for an admin(not me) that uses the local client.

We have some duplicate picklists for a field on a tab in Contacts.

I can find the picklists that are duplicate in the database (SQL below), I don't want to create orpan records by just deleting some duplicate from the PICKLIST table.  I don't know how these relate back to the contact record so I can merge them before deleting the unused picklist rows.  

<pre>
DECLARE @pickname VARCHAR(50)

SET @pickname = 'Conference Attended'

 

SELECT TEXT, count(*) FROM [SYSDBA].[PICKLIST]

WHERE PICKLISTID = 

( 

SELECT ITEMID FROM [SYSDBA].[PICKLIST]

WHERE text = @pickname

)

GROUP BY TEXT

ORDER BY COUNT(*) DESC 

Outside of Picklists in Tickets......very few Picklist controls link the Picklist ID to the Picklist to retrieve the value.....it's simply datavalues that are stored.....

So simply eliminiating the picklist duplicates will be fine......one caveat.....the ADMIN owned row should NOT be deleted unless it's a duplicate of another owned Admin owned picklist value for the same picklist......All Users see Admin owned rows, plus their User created rows (if any).....so make sure you don't delete the remaining Admin owned picklist item.....

Thanks!

Looks like IIS needs to be restarted and the broswer history/temp files need to be deleted for web users to see the change.