Jumat, 19 Februari 2016

RE: [MS_AccessPros] Join me in a discussion of .... joins

Thanks John,

I have renamed my tables. The primary table is tblPeople. The other three are subclass tables, tblButchers, tblBakers, and tblCandleStickMakers. When I was setting up the demo, the query designer autojoined according to scenario 2. The query does not need to be updateable; it is simply for output purposes.

I don't understand your second scenario. It would be clearer if you coded the FROM clause that you're using.

Note that if tables 2, 3, and 4 are all related to table 1 1-to-many, then a query including all four tables will not be updatable because you will be creating the Cartesian Product of all rows in 2, 3, and 4 that are related to 1.