In my "Customers" database (a list of contacts) I have an element, Checkcode, that combines characters from Company, City and State. The visibility of Checkcode is set to 0 (not visible) when the user is in Add or Update mode.
For my On-Retreive-Spec-Open event, I have the following code:
var vCheckcodeLookups as string
// Makes the Checkcode visible for lookups
Visibility(Checkcode, 1)
// Populates the Checkcode combo box
vCheckcodeLookups = @XListValues(@FN, "Customer!Checkcode")
vCheckcodeLookups = @SortstringArray(vCheckcodeLookups,0)
PopulateListElement(Checkcode, vCheckcodeLookups)
This is working well, giving the user a list and setting the value of the element so all he has to do is press F10 to retrieve the matching Customers. However...
Many of our customers have an ampersand in their company name, and Sesame balks at retreiving them because of this. Is there a way to program the retrieve spec so that if the company name includes an ampersand it is ...what's the word? Allowed? Literal? Whatever it is, I think it's a forward slash that needs to be dropped in before the &, but I'm not sure how to go about it.