Hi Everyone,

I am having a problem with a find form based on CFindForm used in conjunction with a form subclassed from cBizObjNoListMaintForm.

The maintenance form is used to update memberships. Each membership has one person who is considered the master member, and may have one or more associate members (spouse, children, etc.) Each member gets a membership number in the following format: 999-9999999-99, where the first three digits (prefix) represent the club, the next seven digits represent the membership number, and the last two digits (suffix) represent the specific member (80 - master member, 81 - first associate, 82 - second associate, etc.)

OK, here's the problem. Sometimes, not always, when the user searches for a member with the find form, the member appears in the find form's grid. But when the user selects the member, the member is not retrieved. The user claims this usually happens with members she has just entered into the system. I am unable to recreate the problem on my system so far. I placed a print button on the find form to print out the query results of the find form. All of the records have a masterid (the primary key to the master table).

The maintenance form has four tabs. The first tab is used to maintain the master member's information. It contains the primary business object, MasterObj. The second tab has a grid that lists the associates (based on CListObjEdit).

The view for the MasterObj is very straight forward:

CREATE SQL VIEW lv_Master AS ;
SELECT * FROM aaamem!master WHERE masterid == ?vp_masterid

The view for the find form is set up to query the master member table and the associate member table :

CREATE SQL VIEW lv_MasterFind AS ;
SELECT Master.lname, Master.fname, Master.mi, Master.clubno, ;
Master.memno, Master.suffix, Master.masterid, ;
SPACE(6) AS associd ;
FROM aaamem!master ;
WHERE Master.memno = ALLTRIM(?vp_memno) ;
AND UPPER(Master.lname) = UPPER(ALLTRIM(?vp_lname)) ;
AND UPPER(Master.fname) = UPPER(ALLTRIM(?vp_fname)) ;
UNION ;
SELECT assoc.lname, assoc.fname, assoc.mi, assoc.clubno, ;
assoc.memno, assoc.suffix, assoc.masterid, ;
assoc.associd ;
FROM aaamem!assoc ;
WHERE assoc.memno = ALLTRIM(?vp_memno) ;
AND UPPER(assoc.lname) = UPPER(ALLTRIM(?vp_lname)) ;
AND UPPER(assoc.fname) = UPPER(ALLTRIM(?vp_fname)) ;
ORDER BY 1, 2

I know this is a long winded question but I'm stumped. Does anyone have any thoughts?

TIA

George