[DUG] Editing date from two tables

[John Bird]

Some random additions that may or may not apply to your case:

Further to what was said. the components can all use a fixed Datasource for 
the controls on the form, but which dataset this points to can be set in 
code - usual Delphi principle - anything you can set in the IDE can also be 
set in code on the fly.

eg
    if conditionA then Datasource1.Dataset := DatasetA;
    if conditionB then Datasource1.Dataset := DatasetB;

Also I was wondering if there was some possibility for a DBLookupCombo you 
haven't explored, as this effectively links two datasets together by setting 
the Key and Listfield properties (from memory).

One trick I learned from using the Help for the tkbMemTable dataset 
(superset to CLient Dataset) was that disconnecting the datasource from the 
dataset when opening the dataset or posting records to it manually can in 
some cases make a huge increase in speed,  (reconnecting it afterwards).

John