Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

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
Hi,

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.

Thanks!

Dave

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

Server Response from: ETNAJIVE02