asked on

3-tier database application,having master-detail relations

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;
TSocketConnection+TClientDataSet.

wumeng

ASKER

please help me!!!

ASKER CERTIFIED SOLUTION

oraelbis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

swift99

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wumeng

ASKER

thank you all,Now I use master dataset's OnOpen and
OnScroll Event to Filter with master TABLE KEY fields

CleanupPing

wumeng:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.

geobul

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

split points between oraelbis and swift99

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer