You have to do this for briefcase mode. It *could* be faster over a
slow network for non-briefcase mode. But it depends on the records you
return, as explained elsewhere.
Same way you link any two master/detail queries with a TDataSource. I
only use regular datasets to do this, so I can't say if it works with
the StoredProc component, but I tend to consider the storedproc
components to be unnecessary anyway.
For TSQLQuery just make sure the detail DS's param has the same name
as the master DS's field, set the DataSource property of the detail DS
to a TDataSource connected to the master. Then instantiate persistent
fields in the master CDS. You'll see a TDataSetField for the detail.
Specify this as the DataSetField property of the detail DS.
Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
Delphi/InterBase Weblog : http://www.yqcomputer.com/
How to ask questions the smart way: