Re: Master/detail relationship in databases

Posted by WAllison on January 09, 2004 at 19:16:13:

In Reply to: Master/detail relationship in databases posted by Jan Zizka on December 28, 2003 at 14:34:29:

: My problem is that I can't get the master/detail connection between two TDataSets. It works OK with the Delphis tutorial DBDEMOS alias database. But once I create my own database it does not work.
: In detail: when I use the Link Designer dialog only the master fields are detected. Detail fields are not shown as well as Available Index Fields(the drop down menu at the top of the dialog).
: I hope I specified the problem well enough.
: Thank you

Make sure that u have added the fields to the TDataset component eg. right click on TTable click add fields - make sure that u have 2 keys in the child table - one of them should match the key in the parent table - its been a while since i used Datasets - hope i helped a bit.

oh yeah - remember to set the indexes in both Datasets.