Hi,

I have tried in vain to edit p.FIRSTNAME, p.SURNAME
in a TIB_Grid. I have made COVEREDMEM the KeyRelation Table. When I hit the insert button, these fields turn gray?

Thanks

SELECT c.RELATIVETYPEID
,c.RELATIVEID
,c.FUNDID
,c.OPTIONID
,c.MEMBERID
,p.FIRSTNAME
,p.SURNAME
,p.STATUSID

,(SELECT NAME
FROM RELATIVETYPE r
WHERE r.RELATIVETYPEID = c.RELATIVETYPEID)
AS RELNAME

FROM COVEREDMEM c

JOIN PERSON p
ON (p.PERSONID = c.RELATIVEID)

WHERE (c.MEMBERID = :ARELATIVEID)
AND (c.FUNDID = :AFUNDID)
AND (c.OPTIONID = :AOPTIONID)




[Non-text portions of this message have been removed]