Trying to use the CRM_WriteLookup stored procedure.  Finding that the value is put in the lookup table but it appears that the index or something is not being updated.  Does that procedure not update the hash tables? 

This is a trigger to add city names to the pop-up/lookup list when a new one is entered. 

No errors, just seems to not ever show in the popup.

Assist would be appreciated.

Interesting as normally using the built-in sp_ features, that is the way to not mess up the works. 

Understand that the refresh is done at startup.  My question should have been a bit more specific and asked if the hash portions are updated when the sp_CRM_WriteLookup is called.  It appears maybe not.

I am under the impression that there were Lookup_Hash tables but I just discovered that is not the case.  Hash tables exist on Accounts, Contacts, Addresses and a few others.  Hash tables normally help drive searches and increase responses to lookups.  My mistake! 

When one uses sp_CRM_WriteLookup to push a new lookup value in, one would assume that the indexes and the "pulldown abilities" are updated. 

I understand the prior responses and have found that the values are put into the lookup table and next cycle INTO RedHorse, the values are indeed there.  Would be nice to be able to see them without the restart but, for now we live with it that way.

Issue resolved unless there is a way to "see" those values in the lookups immediately.