Me again,

First of all, thanks to everyone who's being patient with my many, many questions!  I appreciate the help.

I'm currently trying to figure out XLookupSourceListAll, so I built a test database with the fields FirstName, LastName, RecNo, and MatchNo.  I have it running the code below to search for matching first names on form entry.

My questions are this:

1) How can I exclude the current recorod from the search?

2) How can I best add just the RecNo to the keyword field MatchNo?

Thanks!
Blair

==================================

var vRawName as String
var vMatchName as String
var vPickName as String

vRawName = LastName

if @Mode() = 1 THEN
{      
     vMatchName = @Replace(@XLookupSourceListAll(@FN, vRawName, "LastName", "LastName;FirstName;RecNo"), ";", ", ")
     if vMatchName <> "" THEN
     {
           PopupSelectPosition(3, 250, 150)
           vMatchName = @Replace(vMatchName,@newline(), ";")
           vPickName = @Popupmenu(vMatchname, "SELECT MATCH")
           MatchNo = Matchno + vPickName
     }
}

Hi Bob!

That's exactly what I'm looking to do -- unfortunately, I don't know what command to use to exclude data, and there's nothing immediately apparent in the programming guide.

Can someone tell me how to exclude a single record from a series of returned data from XLookupSourceList?