Devart Forums

Hello,


I have a Table Customer (CustomerNO,Name )Primary Key : customerno
data Customer : 1 ,one
2 , two


then a Table Sales (Salesno,Date, CustomerNo) SalesNo is Primary Key.
data sales : 001, 2013/7/1, 1
002, 2013/7/1, 1
003,2013/7/1, 2


qryCustomer.SQL.Text := 'SELECT * FROM Customer';


qrysales.SQL.Text := 'SELECT * FROM Sales WHERE CustomerNo = :CustomerNo';


qryCustomerdatasource.DataSet := qryCustomer;
qrysales.MasterSource := qryCustomerdatasource;

qrycustomer.open;
qrysales.open;

why after qrysales.open i can not see any record ini qrysales even if i move to another customer ? whats happened in qrysales? thanks a lot.

I think because QrySales has a WHERE clause...

On the detail dataset (qrySales), in addition to the MasterSource property, you need to also set the MasterFields property (clicking on the ... button in property editor will open a dialog window where you can do this. This will also set the DetailFields property).

Hello.

I couldn't reproduce the issue. Please provide the following information:
  - the server version;
  - a simple project demonstrating the problem.
You can send me this information to dmitryk*devart*com

hello,

problem solved.. thanks for All...

If any other questions come up, please contact us.