Hi

I have added an example for clarification.4 tables:
- contact
- group
- groupcontact (contains contacts per group)
- messagesend

then
- groupcontact has a master / detail with group
- groupcontact has lookup fields to contact to have contact information

issue
formMainWhen navigate the dbgrib above the corresponding group members are showed in the dbgrid at the right.When a ADD a new record, the group members in this dbgrid are still visibile but because there is no group selected the dbgrid must be empty.I think i have a wrong master / detail and the lookup but don't see it anymore where i going wrong

Missing example, i will post it in the BINARIES

Peter

<<I think i have a wrong master / detail and the lookup>>

You certainly have

The DBGrid is linked back to MessageSend, your master/Detail is linked back to GroupList so that when you click the button to create a new MessageSend record GroupList is not affected at all.

GroupContactList should have:

IndexFieldNames:    GroupID
MasterSource:        dsMessageSend

then it should work

Roy

Thanks Roy ... and that makes sense ... I didn't see it anymore.


Roy Lambert wrote:

Peter

<<I think i have a wrong master / detail and the lookup>>

You certainly have

The DBGrid is linked back to MessageSend, your master/Detail is linked back to GroupList so that when you click the button to create a new MessageSend record GroupList is not affected at all.

GroupContactList should have:

IndexFieldNames:    GroupID
MasterSource:        dsMessageSend

then it should work

Roy