Thanks Helen!!!

I will look into KeyRelation and the KeyLinks settings - that sounds
like what I need!

Both Access and MS SQL (7+) appear to allow editable/live joined
datasets... with a few caveats of course<grin>.

As for the SQL syntax... well back in the 80's that SQL was pretty as
a picture... I am slowly forcing myself to use the new(er) syntax...
it is just taking a few years. :)

When you have lets say 4 joined tables... is is better/worse to use
parens in the FROM clause and how do you "know" to join one set of
tables "first" and then add the next one or maybe the other one??? Is
there a correct order to place the JOINS or will the optimizer ignore
me (which it probably should) and join the tables the way it thinks
is best.... and is that still the case if I use parens (correctly or
incorrectly)???

Thanks a ton! - I sure need your book about now! :)
--Raymond