Re: Master-Detail using disconnected recordset


----- Original Message -----
From: "Joe" <joemathewwin@xxxxxxxxx>
Newsgroups: borland.public.delphi.database.ado
Sent: 06/07/2006 9:18 PM
Subject: Master-Detail using disconnected recordset


Hi,

I need to implement a master-detail grid. The datasets (TADOQuery in my
case) linked
to the grid makes use of disconnected recordsets. I would like to know the
best
way (the most appropriate dataset/grid events) to filter the detail grid
and
show
the relevant records based on the currently selected master record.

Regards,

Joe



Greets joe,

Its very easy ! First rule is to create two datasets ie. master and detail.
Now select your detail dataset and in the property *** goto Datasource and
select your master dataset (make sure you have set a connection object for
both of them, if you want to see results immediately then turn the Active
property true for both) this becomes your master for the details. Now you
must specify a primary key fields that are common in both master and detail
from the property *** select Masterfields. Now select the primary fields
that are common to both your master and detail and add them to the Joined
Fields listbox.

Thats it baby ! all done no code. A very good article for this topic can be
found on delphi.about.com.


.

Quantcast