Erika, in your programming example post of filtering an xuserselect list, you use the line:

  vFinalList = FilterValueList(vVals, vSearch)

Where can I learn about the programming command "Filervaluelist". I looked in my manual and didnt see it. Is it a 'prototype' command?

Are there other commands we can use in sesame that are not listed in our manual?

Thanks,
Steve

Yes, thats were I saw it but I didnt realise that you created a variable called "function filtervalue", Im just used to seeing variables with short names that start with a 'v'.

Thanks for clearing up my confusion, as always!

Steve in Texas

Oh boy, I skipped that page 

I'll read up on it.

Thanks again!

Steve in Texas

   Lindy, I am in the midst of proofing the May issue of Inside Sesame.  ( http://www.insidesesame.com )
  I don't think it's proper for me to say too much about this issue, but I feel certain Marble Publications wouldn't mind that I mention there is an excellent article dealing with Picklists in Sesame in the upcoming issue!  It should help you a great deal with your situation.  Usually, new issues are available for download around the first of each month, but it is possible (not guaranteed) that the May issue may be available as soon as late Wednesday, 4/28/04.  I hope that you are a subscriber to Inside Sesame, so that you can get this issue ASAP!

Lindy,

XUserSelectR should work based on what you describe. If you want the names beginning with "TRA", have you tried something like:

MyVar = @XUserSelectR(@FN, "Companies!Company Name", "Company Name", "TRA", "TRAzzzzzzzzz")

[quote] 1.  Which fields/events does all of this coding belong in?[/quote]
Where you put the code depends on when you want it to run. For example, if you need it to run when you leave an element called "LastName", put it in the LastName::OnElementExit event.

[quote] 2.  How do I get the "op" out of the programmed function?
3.  I really want the filter for names BEGINNING with, not CONTAINING (I get lots of words containing op and a little white -- blank -- screen that I have no idea what to do with) [/quote]
If you still want to use FilterValueList, the hardcoded "op" can be replaced by the element name containing your beginning characters. If this element is called "NameFilter", the code would look like this:
[code]vSearch = NameFilter[/code]

However, FilterValueList is written to find the search value anywhere in  each list value. It would need to be adjusted to search only at the beginning.

I recommend you just use XUserSelectR instead.

[quote]4.  The picklist of company names -- no matter which method I use -- doesn't display ampersands, which a lot of company names do contain.  So then my lookups don't work for those companies.[/quote]
Special characters like ampersands are always a problem. Most Windows controls see an ampersand as a "shortcut" indicator and, instead of showing the ampersand, underline the character following it. If you want to put these values on a picklist, you need to get rid of the ampersands.