Hi,
I have a single CLIENTS table containing people's names & details, including a nullable column to
identify another person in this table who is the current persons' supervisor.
I was hoping to have a form for this table with a TIB_Checkbox to toggle the forms' display between
a supervisors accounts grid OR that persons' supervisors' name in a TIB_LookupCombo. The problem I
strike with the KeyLinks for the lookup query is trying to set
CLIENTS.SUPERVISORNO=CLIENTS.CLIENTNO, which ain't allowed!
What should I be doing? I didn't want to split clients & supervisors into separate tables because
either one can raise a work request.

Thanks,
Steven Beames