Developer Forum

I have a Master-Detail relationship based on three tables.

I am very well aware that I can setup a query in the detail table and use
parameters to keep the detail in sync with the master.

However, what is the best practice for when a detail is derived from two
master tables such that I would, in essense, need to pass two parameters,
one from one master and another from the second master? Granted, I can set
filters based on the second parameter, but my final goal is to use
ClientDataSets to reconcile the records back to the SQL database.

Is this possible, or do I need to manage this in multiple steps?

TIA

--
Mark A. Deal
Document & Data Solutions, LLC
http://www.yqcomputer.com/
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant

I appreciate the response, Brian. However, the problem appears to remain
and I cannot figure out a way around it.

Whenever I attempt to edit the detail query, I get an error message that
says that the Detail_ClientDataSet does not have a Data Provider or missing
data packet.

Any thoughts?

--
Mark A. Deal
Document & Data Solutions, LLC
http://www.yqcomputer.com/
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant

master

This works, but I've tracked the problem down to the fact that I am
developing in Intraweb. It would appear that the on-scroll method gets
called repeatedly to populate the data fields in such a way that it leaves
the ClientDataSet in a non-edit state.

In other words, I get the following ...

Navigator.Edit
Master1 ==> onScroll
Master1 ==> onScroll
Detail ==> Cancel
Master2 ==> onScroll
Master2 ==> onScroll
Master2 ==> onScroll
Detail ==> Cancel
..

I'll post this over in Intraweb and see what I can find. Thanks for
clarifying that I'm not completely crazy. :~)

--
Mark A. Deal
Document & Data Solutions, LLC
http://www.yqcomputer.com/
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant

to the
the
the