Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Master/Detail
Thu, May 14 2020 2:53 AMPermanent Link

Peter van Mierlo

EVENTSOFT

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
Thu, May 14 2020 2:57 AMPermanent Link

Peter van Mierlo

EVENTSOFT

Missing example, i will post it in the BINARIES



Attachments: dbisamexemple.zip
Thu, May 14 2020 8:31 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Peter

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

You certainly have Smiley

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

Thu, May 14 2020 9:32 AMPermanent Link

Peter van Mierlo

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 Smiley

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
Image