I have a problem when I develop 3-tier database application with nested client dataset component (having master-detail relations). When the selection result of the master dataset has more than one records, the detail dataset (nested dataset) displays correct records which corresponds to the master record only, but when the selection result of the master dataset has only one record, the detail dataset (nested dataset) selects and displays all the detail records from the database table which corresponds to the detail dataset. I’ve been trying to solve this problem and also discussing with many friends, but no answers. I have to find an answer from you. Would you kindly give me an answer?
I use delphi5,win2k,TADODataSet+TDataSetProvider;