Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: Master --> Detail --> Sub Detail

This question is not answered. Helpful answers available: 2. Correct answers available: 1.

Permlink Replies: 0
David Cox

Posts: 28
Registered: 7/6/07
Master --> Detail --> Sub Detail  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 1, 2016 7:18 AM

I have a master detail relationship in a query where the detail references the master via a parameter such as "Where Detail.MasterID = :MasterID". This work well. I now want to add a sub detail that links to the detail table (not the master) as in:

Master Table --> Detail Table --> Sub Detail Table

So the sub detail would be something like "Where SubDetail.DetailID = :DetailID"

Is this possible? How would it be setup in Delphi? I have tried various techniques but I have not had any success.



Edited by: David Cox on Nov 1, 2016 10:18 AM
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02