Self Referencing table

[sermac]

Hi: I have a rolodex table, I added a dropdown combo with the following sql. . .referencing back to 2nd index rolo_IDspouse. . .

Select Alltrim(name_first)+' '+Alltrim(name_mi)+' '+Alltrim(name_last),rolo_ID from Dex_Name Order by name_last into Cursor cboSpouse

How shd I rework the sql whereby the dropdown would "not"
list the record of the record I am sitting on?

Husband is in the rolodex, Wife is in the rolodex. I can pick Wife to Husband, and Husband to Wife, but am trying to filter the dropdown cboSpouse. (. . .don't want the husband to be able to marry himself! and visa versa. . .)

Appreciate any feedback
THX

Bill

 

[baltman]

I'd make use of the WHERE clause... mabe you have an EntryId or something you could use to 'know' where you are (recno() isn't a good practice).

lnThisEntryId=EntryId
SELE ... WHERE EntryId#lnThisEntryId

Brian