Hi all,

I have the following:-

Table_Member
---------------------
MemberId
FirstName
Surname

Table_MemberBen
---------------------------
MemberId
BenId


Table_Beneficiary
-------------------------
BenId
FirstName
Surname

I want to be able to display MemberBen.Benid, Ben.Firstname, Ben.Surname in a grid(using a joined query I guess), and be able to insert into
Table_Beneficiary when adding a new Beneficiary to the relationship(MemberBen). I want to search for this new Beneficiary on BenId(an embedded IB_lookupCombo in the grid)
, and if not found, direcly(from within the grid) edit/add this new Beneficiary to the Beneficiary table as well as the to the MemberBen table. I want to avoid using a
popup form to enter this info. I would prefer directly editing/inserting in the grid.

Is this possible.

Thanks,
Dion



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