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 } }
|