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?
Mark A. Deal
Document & Data Solutions, LLC
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant