I see that the PICKLIST table has all the items for the picklists. I also see that there is a PICKLISTID that says what items go with that picklist. But how do I find out what PICKLISTID matches up with (for example) the Contact Status picklist?
And I need to do this programmatically.
This is how you get all the Picklist Items for a Given Picklist (Using Contact Status as example):
SELECT * FROM PICKLIST WHERE PICKLISTID IN
SELECT ITEMID FROM PICKLIST WHERE PICKLISTID = ‘PICKLISTLIST’ AND TEXT = ‘Contact Status’